I am having big problems with SQL 2000 and a DSN login.

I have used it before, but I have restored the SQL database from a .BAK file from another SQL server.

I can go to the SQL machine and open Enterprise manager, open the desired database and see a list of users. My ID is there and I always use the same password.

Thinking it is possible the password is wrong, I went to the security tab then logins at the server level. I double clicked on sa and changed the password.

However I can NOT setup a DSN using sa and the password.

It tells me:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

Has the restore brought in different IDs and SA on server is not SA on database?

HELP! :-((