Microsoft SQL Login Failed with error code 18456 - Resolution with screenshots

Situation: You can login Windows Authentication, but when attempting to login sa to Microsoft SQL Database, you may receive login failed message as shown below:

Resolution: 1. Login Microsoft SQL Server Management Studio.

2. Right click on SQL server and select Properties.

3. Click on Security and make sure SQL Server and Windows Authentication mode is checked.

Contact a consultant

Related Topics

Bob Lin Photography services

Real Estate Photography services