[Solved-1 Solution] Error 18456, Severity: 14, State: 5. Login failed for user



Error Description:

  • Getting login errors with Java application. And even when we use the SQL Server Management Studio it errors out with Error 18456 code:
login failed

Learn sql - sql tutorial - login-failed - sql examples - sql programs

Solution 1:

  • Add the machine account to your SQL Server. You can first locally log on your SQL Server instance with a local administrator via SSMS, expand Security folder->right click Login->click New Login..., check Windows Authentication and type the machine account "Domain\ServerName$" as the login name, and then you may assign the account permissions by selecting the server roles and specify the related databases by selecting the User Mapping.

Related Searches to Error 18456, Severity: 14, State: 5. Login failed for user