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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Authentication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-04 : 09:30:39
writes "Hi:

My question is

After creating a new login using sql server authentication,
I can't login into my query analyzer using that login although I've provided the correct server name(which was installed in my pc itself), login id, password and my sql server was running.
I got the error message saying "Not associated with a trusted SQL server connection"
May I know how to rectify this problem?
Please help. Thanks

regards
Alex"

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2002-01-04 : 09:35:16
You need to setup SQL Server to accept both integrated and SQL logins. It's under the SQL server properties.

Go to Top of Page
   

- Advertisement -