Re: Login failed for user 'sa'. (Error code: 18456).

From: Robert Bogue ([*]rbogue[spam]crowechizek[spam]com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 10:10:52 -0500

Try to disable named pipes just to get it out of the equation... Try going
to a command prompt and use telnet. 'telnet sqlserver 1433' You should get
a black blank window with a cursor flashing. If not then you don't have
connectivity to SQL server or TCP/IP is not in use, or it's been moved to
another port.

If you do get connected do a Ctrl-] and then type exit.

Rob 

-- 
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Bob Robert" <BobRobert@discussions.microsoft.com> wrote in message
news:BE45DFA5-9C8B-4146-BF49-D6FC05BE2846@microsoft.com...
> I forgot to answer one of your question. We have both TCP/IP and Named
Pipes as client network protocols.
>
> Thanks
>
> "Bob Robert" wrote:
>
> > Hi Rob,
> >
> > Thank you for your quick response. SharePoint Server is behind the
firewall and SQL Server Server is in the domain. We are not using AD setup.
I try to connect database with Windows Auth. and SQL Auth. I did have any
luck so far.
> >
> > Thanks
> >
> > "Robert Bogue" wrote:
> >
> > > What transport mechanism is your default for SQL?  Are the boxes in
the same
> > > domain?  At first glance it looks like it's trying to create a named
pipes
> > > connection and the SPS box has been unable to communicate with the
domain
> > > for so long that it's password is no longer valid.  (The password for
the
> > > computer account in AD.)
> > >
> > > Rob
> > >
> > > -- 
> > > Robert Bogue
> > > Microsoft MVP Server-Networking
> > > MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT
Project+,
> > > Server+, Security+, CDIA+, E-Biz+
> > > Crowe Chizek and Co LLC
> > > "Bob Robert" <BobRobert@discussions.microsoft.com> wrote in message
> > > news:2A6B4286-9002-40D9-A9EE-D645F294A882@microsoft.com...
> > > > http://localhost:24644/configdb.aspx
> > > >
> > > > Database server: SQLSERVER01
> > > > SQL Server database name: SPSQL
> > > > Database connection type:  Use SQL authentication (less secure)
> > > > Database account user name: sa
> > > > Database account password: password
> > > >
> > > > * Connect to existing configuration database
> > > >
> > > > After submitting above information, I get "Login failed for user
'sa'.
> > > (Error code: 18456)." error message.
> > >
> --------------------------------------------------------------------------
> > > -
> > > > Also, I tried windows authentication to access sql server database.
This
> > > time, I got different error message as "Login failed for user
> > > 'DOMAIN\SPSERVER$'. (Error code: 18456). "
> > > > DOMAIN --> Name of the domain
> > > > SPSERVER --> Sharepoint Server behind the firewall
> > > >
> > > > Did any one come across above problem?
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> > >

Relevant Pages

  • RE: change a named instance to default instance
    ... Thanks for the tips, since I'm developing locally, with a local SQL Server, ... After I configured the Alias and port number for TCP/IP in the Server ... it did not initially work until I had disabled the PIPES ...
    (microsoft.public.sqlserver.connect)
  • SQL Server 2005 connection unusually slow even errors.
    ... I have a Win2K3 Server with SS2005 developers edition. ... Windows XP Pro workstation which has SQL Server 2000 installed as well as ... out errors and "can't generate SSPI context" messages. ... manager to change the connection to name pipes, name pipes and tcpip etc, ...
    (comp.databases.ms-sqlserver)
  • Re: Login failed for user sa. (Error code: 18456).
    ... SharePoint Server is behind the firewall and SQL Server Server is in the domain. ... I try to connect database with Windows Auth. ... "Robert Bogue" wrote: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Three processes intercommunicating(both ways) using pipes, (six pipes??)
    ... > Two pipes to which the server process reads and writes to. ... directly from the shared memory block, and decrement the semaphore. ...
    (comp.unix.programmer)
  • Re: Setting up ODBC
    ... I can ping the server without any problem using both the server name ... machine that is not connecting is setup exactly the same as a machine ... pipes I've search on the internet but all I can seem to find is info ... using named pipes it automanically generate the following pipe name: ...
    (microsoft.public.sqlserver.setup)