542000 - Messages "Error:18456".."Login failed for user 'xx'" appear
Symptom 1. Connection failed.. SQL server error: 18456 2. Login failed for user 'XX'
Cause 1.Failure in attempt to connect to server due to a false login ID or a incorrect password. 2. A certain bug exists in SQL that corrupts the System Administrator password.
Solution To solve this problem please perform the following steps: 1. Ensure the System Administrator user was entered in the Login field (or any other user defined by the system administrator) 2. Ensure the correct password was entered in the Password field 3. In case the customer did not define a password for the SA user or for any other user defined by him, delete the content of the Password field. In case a password was not defined for the SA user please perform the following procedure, which must be approved by the system administrator or by the general manager:
1. Go to the taskbar "Start -> Programs -> Microsoft SQL Server -> Enterprise Manager" 2. In your SQL Server click on the folder Security 3. click on Logins 4. Double click the SA user 5. In the pop up window use the General tab to delete the Password 6. Press "OK" 7. Go to the Console in your menu and click on "Exit"
1. In the taskbar click "Start -> Programs -> Microsoft SQL Server -> Enterprise manager" 2. Right click the SQL server 3. Select Properties 4. In the pop up window click on the Security tab 5. In the Authentication field, make sure that both, "Windows and SQL" are checked instead of "Windows only".
Symptom
1. Connection failed.. SQL server error: 18456
2. Login failed for user 'XX'
Cause
1.Failure in attempt to connect to server due to a false login ID or a incorrect password.
2. A certain bug exists in SQL that corrupts the System Administrator
password.
Solution
To solve this problem please perform the following steps:
1. Ensure the System Administrator user was entered in the Login field (or any other user defined by the system administrator)
2. Ensure the correct password was entered in the Password field
3. In case the customer did not define a password for the SA user or for any other user defined by him, delete the content of the Password field.
In case a password was not defined for the SA user please perform the following procedure, which must be approved by the system administrator or by the general manager:
1. Go to the taskbar "Start -> Programs -> Microsoft SQL Server -> Enterprise Manager"
2. In your SQL Server click on the folder Security
3. click on Logins
4. Double click the SA user
5. In the pop up window use the General tab to delete the Password
6. Press "OK"
7. Go to the Console in your menu and click on "Exit"
1. In the taskbar click "Start -> Programs -> Microsoft SQL Server -> Enterprise manager"
2. Right click the SQL server
3. Select Properties
4. In the pop up window click on the Security tab
5. In the Authentication field, make sure that both, "Windows and SQL" are checked instead of "Windows only".