Login to QA on SQL2000 as a 2nd intance

[saad]

Please Help anybody

On trying to connect to QA (of SQL2000 as a second instance) on the server machine using SQL authentication, username sa I get the following error

&#34;unable to connect to server <servername><instance name>
Server Message 18452, Level 16, state 1
[Microsoft}{ODBC SQL Server driver] login failed for user &#39;sa&#39;. Reason not associated with a tusted SQL server connection.&#34;

Any pointing in the right direction will be appreciated.

Saad

[Chris Thibodeaux]

Try just using Windows Authentication. The second instance is created in an entirely different memory space, thus the if you have an sa password, the 2 instances CAN (and probably are) different.

-HTH-


------------
saad at 2/24/01 6:58:07 AM

Please Help anybody

On trying to connect to QA (of SQL2000 as a second instance) on the server machine using SQL authentication, username sa I get the following error

&#34;unable to connect to server <servername><instance name>
Server Message 18452, Level 16, state 1
[Microsoft}{ODBC SQL Server driver] login failed for user &#39;sa&#39;. Reason not associated with a tusted SQL server connection.&#34;

Any pointing in the right direction will be appreciated.

Saad

[yelena]

According to the error you are getting, it seems that your server is configured with Windows authantication only. Check your settings to make sure that you have SQL authantication is enabled.

Yelena

------------
saad at 2/24/01 6:58:07 AM

Please Help anybody

On trying to connect to QA (of SQL2000 as a second instance) on the server machine using SQL authentication, username sa I get the following error

&#34;unable to connect to server <servername><instance name>
Server Message 18452, Level 16, state 1
[Microsoft}{ODBC SQL Server driver] login failed for user &#39;sa&#39;. Reason not associated with a tusted SQL server connection.&#34;

Any pointing in the right direction will be appreciated.

Saad