Login to Microsoft SQL Server Error 18456

Question

When I try to connect to the SQL Server I am getting this error:

Microsoft SQL Server Error: 18456

Can anybody tell me what the error code means?

Answer 1

You might want to change your server authentication if you're trying to login using "SQL Server Authentication":

In the object explorer of Microsoft SQL Server Management Studio:

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.

I hope this helps you.