The database could be offline, shutdown, deleted, dropped, renamed, auto-closed, or inaccessible for some other reason. 38: Error: 18456, Severity: 14, State: 38. As I found out later, States 38 and 40 (in SQL 2008 and later) and States 16 and 27 (before version 2008) mean that there is an issue with the database being connected to. I think you will only see state 28 prior to SQL Server 2008. Reason: Failed to open the explicitly specified database CSP203449DBSPC. 6:29 Logon Unknown Login failed for user CreativeSolutionsPractice CsDatabase Owner. Basic setup: All of the following is installed on DomainServername: SharePoint 2013 Standalone Install (Trial version) Currently using an instance of SQL Server 2012 SP1 Express for basic SharePoint databases (upgraded from SQL Server 2008 R2 Evaluation).

When you saw error like ' Login failed for user '' ', these are authorization failure, which is related to your SQL server security settings. Msg 18456, Level 14, State 1, Server , Line 1 Login failed for user We should know that the State will always be shown to be 1 regardless of the nature of the problem. I have not experienced this issue but I suspect it involves overloaded connection pooling and connection resets. 6:29 Logon Unknown Error: 18456 Severity: 14 State: 38.

' or ' Login failed for user '(null)' ' or ' ANONMOUS LOGON', these are authentication failure. When you saw error ' Login failed for user ' '.

Run Management server wizard and replaced the connection details with SQL authentication and 'sa' account and the errors should stop being logged.įor using the previous account the customer should assign it the correct permissions.ĭifferenciate Authentication failed and Authorization failed. The doesn't have the correct permissions in the SQL server or database.

Sql error 18456 severity 14 state 38