Check server's error log where a corresponding entry will be written.

The key to the message is the 'State' which the server will accurately set to reflect the source of the problem. The common error states and their descriptions are provided in the following table:

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

18 Change password required