Sunday, February 19, 2012

About server authentication

Hi,
I've enabled the SQL Server and Windows Authentication mode, and then I
restarted the SQL server. My ASP.NET program can be access the server, but I
found that I cannot login the SQL server using Microsoft SQL Server
Management Studio.
I checked the ERRORLOG on my server, which shows following information. I'm
sure my password is correct.
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'sa'. [CLIENT: <local machine>]
Error: 18456, Severity: 14, State: 8.
Login failed for user 'sa'. [CLIENT: 192.168.200.1]
Any suggestion for it?
Many thanks~
Yes, I'm using SQL Server 2005, and enabled the "sa" account.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23eA$s%23yWHHA.1396@.TK2MSFTNGP05.phx.gbl...
> Are you on 2005? If so, is the "sa" account disabled?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Daatmor" <daatmor@.mail.hongkong.com> wrote in message
> news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
>

No comments:

Post a Comment