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)
 SQL Connectivity with sa only

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-12 : 09:23:41
Inder writes "Sir, I wanted to connect to SQL Server from query analyzer with sa and password only.
i.e. from Query analyzer, SQL should not be connected with windows authtication..
i checked with mixed/mode/securitywith sa password...it works in Enterprise manager but not in QA.

Pl. reply.

regards

Inder"

rlaubert
Yak Posting Veteran

96 Posts

Posted - 2007-03-13 : 07:52:31
Inder,
Are you getting any error message. What indication are you getting that it is not connecting? Is this a local server or are you connecting over the network?

Raymond Laubert
MCDBA, MCITP:Administration, MCT
Go to Top of Page
   

- Advertisement -