Archive

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

MSSQL Logon Error 18456 Fix