>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! :-((

Joel,

It appears that your using Windows authentication. If so, you won't be able to change the password on the SQL Server level. You'll have to do it on the Windows level.