February 22, 2012 at 9:40 am
Hi,
I found one login is not able to login to SQL even the login is available in SQL. So I wish to know that what is the root cause and how to trouble shoot this senario.And the networking also fine it is pining.
Kindly give me the navigation to trouble shoot.
Thanks and Regards.
February 22, 2012 at 9:46 am
you should see the login failure reported in the SQL errorlog with some information as to the cause, including an 'error state'.
Hers a list of the common reasons and their state no:
ERROR STATE
ERROR DESCRIPTION
2 and 5
Invalid userid
6
Attempt to use a Windows login name with SQL Authentication
7
Login disabled and password mismatch
8
Password mismatch
9
Invalid password
11 and 12
Valid login but server access failure
13
SQL Server service paused
16
no permission to login to target database (default database or database specified in connection)
18
Change password required
27 Initial database could not be found
38 Login valid but database unavailable (or login not permissioned
---------------------------------------------------------------------
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply