General information
Forum:
Microsoft SQL Server
Through Enterprise Manager, right click on the instance and click properties. Select the Security Tab and make sure the authentication mode is set to SQL Server and Windows and not just Windows. If you need to change it you must restart SQL Server in order for it to take effect.
Regards
Jon
>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! :-((
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only