What if you do not know the database the log on user is attempting to connect to? In such scenarios, in SQL Server Management Studio (SSMS) connect to that instance using an Admin account and in object explorer expand databases to see if that database exists and what state is in. You will notice in the error that the name of the database is not specified. Now to fix this error, we have to attempt to log into the SQL Server to understand what is going on with the specified database. Few possible reasons include the database could be offline, shutdown, deleted, dropped, renamed, auto-closed, or inaccessible for some other reason like corruption. Please be noted that the Error State no and Description can vary across SQL Servers like States 38 and 40 (in SQL 2008 and later) and States 16 and 27 (before version 2008) to indicate that the specified database does not exist. įixing the error 18456, Severity: 14, State:38Īs explained above, error state number 38 clearly mentions that the Specified database does not exist or inaccessible. Reason: Failed to open the explicitly specified database. 12:19:34.56 Logon Login failed for user '\ 38 for error 18456 while trying to authenticate on Microsoft SQL Server and address how to fix it. In this article, we’ll take a closer look at State no. SQL Server is configured to allow Windows Authentication only and a client connects using SQL Authentication.ĭatabase requested by user does not exist This state usually means you do not have permission to receive the error detailsĪttempt to use a Windows login name with SQL AuthenticationĪuthorization is correct, but access to the selected database is not allowedĬould not find database requested by user 18456 from MSDN below.Įrror information is not available. Please find below the various Error State no. Majority of the Authentication related errors might arise due to incorrect username or password, disabled SQL Authentication mode, expired password, deleted user account or non-existent database. which will be helpful to identify in more detail about the Login Authentication failure. SQL Server will provide an Error State no. One of the most common issues faced while connecting to a SQL Server instance is "Login failed for user 'username'.#Sql error 18456 severity 14 state 11 how to#
#Sql error 18456 severity 14 state 11 windows#