>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.
George
Ubi caritas et amor, deus ibi est