Login failed for user ‘%.*ls’.%.*ls

Details
Product: SQL Server
Event ID: 18456
Source: MSSQLServer
Version: 10.0
Component: SQLEngine
Symbolic Name: LOGON_FAILED
Message: Login failed for user ‘%.*ls’.%.*ls
   
Explanation

When a connection attempt is rejected because of an authentication failure that involves a bad password or user name, a message similar to the following is returned to the client: “Login failed for user ”. (Microsoft SQL Server, Error: 18456)”.

Additional information returned to the client includes the following:

“Login failed for user ”. (.Net SqlClient Data Provider)”

——————————

“Server Name: “

“Error Number: 18456”

“Severity: 14”

“State: 1”

“Line Number: 65536”

The following message might also be returned:

“Msg 18456, Level 14, State 1, Server , Line 1”

“Login failed for user ”.”

   
User Action

If you are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode.

If you are trying to connect using SQL Server Authentication, verify that SQL Server login exists and that you have spelled it properly.

If you are trying to connect using Windows Authentication, verify that you are properly logged into the correct domain.

If your error indicates state 1, contact your SQL Server administrator.

Related:

Leave a Reply