Unable to connect using sql authentication -

[lqqkn2]

Hello

Running SQL 2005 - since the weekend, we have been unable to login using sql authentication - we didn't change anything in the envirnomnet. We can connect using windows authentication - i have changed the sa password, checked to ensrue mixed authen., even created a new sql authen. user and receive the same error. I know state 8 reports a missmatched password.

Does anyone have any idea's?

thank you



Date 1/22/2008 3:29:53 PM
Log SQL Server (Current - 1/22/2008 3:29:00 PM)

Source Logon

Message
Login failed for user 'sa'. [CLIENT: 192.168.5.24]

Date 1/22/2008 3:29:53 PM
Log SQL Server (Current - 1/22/2008 3:29:00 PM)

Source Logon

Message
Error: 18456, Severity: 14, State: 8.

 

[mrdenny]

What error gets returned to the client?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[lqqkn2]

This error is when trying to connect through management studio

 

[mrdenny]

What's the verbiage that comes up on the screen when you try to connect via the management studio.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[lqqkn2]

Cannot connect to SQL01

Additional information:
login failed for user sa (microsoft sql server, error 18456)

**This is with sql server authentication

IF i connect using windows authentication, and look at the error log, the 1st post contains that information.

I have even tried created an additional login, and that fails. I have checked to ensure tcp/ip is enabled.

 

[mrdenny]

This blog shows what the various states mean.

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

State 8 is a wrong password issue. Passwords are case sensitive now. Caps Lock perhaps?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog