Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not associated with a trusted SQL Server connection
Message
From
03/10/2005 03:32:27
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
 
To
02/10/2005 01:23:46
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01055301
Message ID:
01055421
Views:
9
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
Map
View

Click here to load this message in the networking platform