MS SQL Server ODBC - Login Failed for User 'sa'

Author

Login Failed for User 'sa'

Bob Bartel

2005-08-11, 1:24 pm

I have an interesting problem. I am using the ODBC administrator to connect
to a central SQL server over a WAN. On the workstation at the remote site
I am able to "see" the server PC in the windows explorer, but on some remote
workstations I can not connect, and I get a 18456 error that my login fails.
Yet, on other remote sites I can connect just fine. BTW I have the latest
ODBC drivers installed. (Also, I am sure of the password, as I tried at
least six times, and I was able to connect earlier from other remote sites).

Can anyone give me any ideas what's going on?

Exact Error message:

Connection Failed
SQL State 28000
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'

Thanks in Advance!!

Bob Bartel

Matt Neerincx [MS]

2005-08-22, 3:23 am

This is usually a pretty cut and dried error message, it means the password
is wrong. It can also mean the server admin switched the SQL Server to
integrated login only mode. I would not suspect that this is due to the
driver or client configuration, but more likely network or server side.

One thing you can try is forcing named pipes and forcing tcp-ip to see if
one or the other works.

When you enter the server name, prefix it with tcp: or np: to force tcp or
named pipes protocols, for example ->

np:mysql

tcp:mysql

Matt Neerincx [MSFT]

--
This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Bob Bartel" <jmail@marketware.us> wrote in message
news:eICXLWonFHA.1148@TK2MSFTNGP12.phx.gbl...
>I have an interesting problem. I am using the ODBC administrator to
>connect to a central SQL server over a WAN. On the workstation at the
>remote site I am able to "see" the server PC in the windows explorer, but
>on some remote workstations I can not connect, and I get a 18456 error that
>my login fails. Yet, on other remote sites I can connect just fine. BTW I
>have the latest ODBC drivers installed. (Also, I am sure of the password,
>as I tried at least six times, and I was able to connect earlier from other
>remote sites).
>
> Can anyone give me any ideas what's going on?
>
> Exact Error message:
>
> Connection Failed
> SQL State 28000
> SQL Server Error: 18456
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'
>
> Thanks in Advance!!
>
> Bob Bartel
>
>

Sponsored Links