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~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.ph
x.gbl...
> Hi,
> I've enabled the SQL Server and Windows Authentication mode, and then I re
started the SQL server.
> My ASP.NET program can be access the server, but I found that I cannot log
in 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...
>|||Next step would be to change the password for sa to something known, I guess
.
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:ORVoiO6WHHA.1432@.TK2MSFTNGP02.ph
x.gbl...
> Yes, I'm using SQL Server 2005, and enabled the "sa" account.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%23eA$s%23yWHHA.1396@.TK2MSFTNGP05.phx.gbl...
>
No comments:
Post a Comment