Unable to Connect to SQL Server Due to Error: 18456, Severity: 14, State: 12
Table of Contents
SQL Server Error: 18456 Severity: 14 State: 12 or Error: 18456, Severity: 14, State: 12 Login failed for user ‘Username’ issue is caused by permissions issue. The following error appears in the SQL Server log:
Login failed for user 'Username'. Reason: Login-based server access validation failed with an infrastructure error. Check for previous errors. [Client: 10.0.0.1]
Error: 18456, Severity: 14, State: 12
Error: 18456, Severity: 14, State: 12 means that the authentication is successful to the SQL Server but the server access fails due to permission issue. Below is resolution
Need to ensure that the SQL Server Authentication mode is enabled for this login method to work.
Below are SQL commands to master database to give the permission to connect via TCP/IP for the User which should fix this issue
GRANT CONNECT SQL TO "Username"
GRANT CONNECT ON ENDPOINT::"TSQL Default TCP" TO "Username";
Learn about SQL Server detecting logical consistency based issues and how to resolve them.
Learn about SQL Server error 1222 and how to resolve the lock request time out…
Discover the new features of Microsoft SQL Server 2022 and how they compare to previous…
SQL Server Error 1222 lock request time out period exceeded Lock request time out…
SQL Server Error : 427, Severity: 20. Could not load the definition for constraint ID…
SQL Server Error : 204, Severity: 20. Normalization error in node %ls.
This website uses cookies.