Unable to login to SQL Server + SQL Server Authentication + Error: 18456

Question

Hello

I have created login account on my localhost\sql2008 Server (Eg. User123)

Mapped to Database (default)

Authentication Mode on SQL Server is set to both (Windows and SQL)

But login to SQL Server fails with following message (for User123)

Note: Have checked multiple time that UserName / Password are typed in correctly

Error Details:

Login failed for user 'User123' (Net.SqlClient Data Provider)

Server Name : localhost\sql2008 Error Number: 18456 Severity : 14 State : 1 Line Number : 65536

any help on this please.

Thanks

Answer 1

Check out this post,

It shows how to trouble-shoot this error:

http://sqlserver-qa.net/blogs/tools/archive/2007/05/18/msg-18456-level-14-state-1-server-servername-line-1-login-failed-for-user-name.aspx

Answer 2

I had this same problem, however mine was because I hadn't set the Server authentication to "SQL Server and Windows Authentication mode" (which you had) I just wanted to mention it here in case someone missed it in your question.

You can access this by

• Right click on instance (IE SQLServer2008)
• Select "Properties"
• Select "Security" option
• Change "Server authentication" to "SQL Server and Windows Authentication mode"
• Restart the SQLServer service
  • Right click on instance
  • Click "Restart"