Re: SQL LOGIN ERROR
2001-09-26 07:26:27
Subject: |
Re: SQL LOGIN ERROR |
From: |
Richard Sims <rbs AT BU DOT EDU> |
Date: |
Wed, 26 Sep 2001 07:23:16 -0400 |
> ACO4210E -- Failed to connect to SQL server.
>
> Anybody knows why??
> Appreciate any suggestions..
Some possibilities:
ACO4210E -- Failed to connect to SQL server.
Try using the following options on the "sqldsmc" command to specify a
valid SQL Server user id and password:
/SQLUSer:username (default: sa)
/SQLPWD:password (default: "")
or use the following option when using a trusted connection (Windows NT
is used to authenticate the user.): /SQLSECure
If the GUI client works fine but the command line client is encountering
this message, it indicates that someone at one point provided the
correct sqluser and pswd info to the GUI (which then got stored in the
Registry). Both the command line and GUI will use "sa" as the default
sql userid if none is provided, but if that is incorrect, the GUI will
prompt the user to enter a different one and then stores that in the
Registry. If you supplied sqluser and sqlpswd on the command line, they
seem not to be the correct ones. The command line does not currently
look for stored userid/pswd values in the Registry.
Rebooting the NT system is also reported to eliminate the message.
Richard Sims, BU
|
|
|