User is not associated ... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

User is not associated ...

Author

Topic

sanj
Starting Member

22 Posts

Posted - 2008-12-21 : 21:04:26

Hi,

I am new to SQL and have been using Access previously, I have installed MS SQL
2005 Standard Version.

When I added a a user to a DB everything seems OK, then I tried to create a ODBC System DSN connection with the user added and got an error message:

'User is not associated with a trusted SQL server connection'

A looked up the error on the web and found that I need open the instance as a SQL Server Authentication.

So in the Management Studio:

In Object Explorer,
Connect > New Database Engine > Server Name 'localhost' > Authentication > login > user1 > passowrd > 1234

Doesn't work - what am I doing wrong?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-21 : 22:56:47

When you installed SQL Server, did you specify to use mixed-mode authentication? The default is Windows only. If you don't recall or know you kept it at the default, then check out the Security page when you right click on your server in Management Studio. You must do it with an account that has high level of permissions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sanj
Starting Member

22 Posts

Posted - 2008-12-22 : 16:25:27

thanks for that, got that sorted.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources