ADSM-L

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
<Prev in Thread] Current Thread [Next in Thread>