Logon Failed for User Error 18456 Event ID: 18456 MSSQLSERVER Logon
Quick solution for MSSQL Server logon error for local user:
1. From SQL server Management Studio logon with Windows Authentication.
2. Right-Click on your server name in left pane
3. Click Security and Click SQL Server and Windows Authentication Mode
4. Click OK and restart the SQL service
