SQL Server Performance Forum – Threads Archive

login failed for user

Msg 18456 level 16 state 1
[Microsoft][ODBC SQL Server Driver][SQl Server] login failed for user’abc45′.I checked the sid in both sysxlogins and sysuser they are same.What is the problem then.Pls suggest

If the login worked in the past then there must have been some sort of change. Incorrect password? No access permission to database that is set as the default for the login? Also, is this when working at the console or at a workstation? Network user may not (or no longer) have access to the server. Maximum number of connections may have been exceeded.

When I tried to connect to the server using this login by QA I got this error msg.

What is the authenticatio method used to connect SQL SErver? To use standard SQL Server authentication to establish a connection, it is essential that you configure the security settings on the target SQL Server to permit Mixed mode (NT and SQL Server) authentication. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>