Login to Microsoft SQL Server Error: 18456

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:

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

Source : Stackoverflow