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~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...
> 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...
>> 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~
>|||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.phx.gbl...
> 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...
>> 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~
>>
>