sql-serverconnectionerror-code

Login to Microsoft SQL Server Error: 18456


I am getting this error while trying to connect to the SQL Server.

Microsoft SQL Server Error: 18456

Can anybody tell me what the error code means?


Solution

  • If you're trying to connect using "SQL Server Authentication" then you may want to modify your server authentication:

    Within the Microsoft SQL Server Management Studio, in the Object Explorer window:

    1. Right-click on the server and click Properties

    2. Go to the Security page

    3. Under Server authentication, choose the SQL Server and Windows Authentication mode radio button

    4. Click OK

    5. Restart SQL Services