You can go to SQL server and reset the password for sa.
When set up ODBC connection, make sure you use "With SQL Server authentication using a login ID and password entered by user"
Go to SQL server Enterprise Manager, go to SQL Server Properties (Configure) > Security. Make sure you choose Authentication method as "SQL Server and Windows".
Hope this helps.