Microsoft SQL Server, Error: 18456 – Login failed for user.

If you encounter this error while connecting to the SQL Server  SQL authentication, the solution is simpe.

Connect to the server with Windows Authentication

Just check 2 things:

1. Go to Security -> Logins and right click to the user -> Properties -> Status
Login section should be Enabled

2. Right click to the Database Engine, Go to Properties -> Security 
In Server Authentication section, make sure

SQL Server and Windows Authentication Mode is selected.

It would need a SQL Server restart, which you can do by:
Start - > Run - > Services.msc

Go to SQL Server  and Restart it.

Thats all !

HTTP Error 500.19 - Internal Server Error

If you install IIS 8 on Windows 8 you might experience this problem.

To resolve this:

Run cmd as Administrator, type:

cd C:\Windows\System32\InetSrv

Run both commands:

appcmd unlock config -section:system.webServer/handlers
appcmd unlock config -section:system.webServer/modules


That 's it