Ms Sql Server Error 18456 Severity 14 State 38
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the
Error 18456 Severity 14 State 38 Sql 2008 R2
company Business Learn more about hiring developers or posting ads with us Database Administrators Questions error 18456 severity 14 state 38 nt authority system Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish login valid but database unavailable (or login not permissioned) to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are
Error 18456 Severity 14 State 1
voted up and rise to the top Login failed for user - Error 18456 - Severity 14, State 38 up vote 12 down vote favorite 4 Message that SQL Server Log File Viewer shows: Login failed for user [User] Error: 18456, Severity: 14, State 38 What it actually means: Failed to open the explicitly specified database My Question: Is there a list somewhere of all the variations of the 18456 errors (Login failed), for
Sql Error 17054 Severity 16 State 1
each combination of severity and state, with the helpful description text? I've had a Google but can't find anything other than specific combinations. sql-server errors logins share|improve this question asked Nov 30 '12 at 16:30 Pete Oakey 2841210 add a comment| 2 Answers 2 active oldest votes up vote 11 down vote State codes and their meaning. 1 'Account is locked out' 2 'User id is not valid' 3-4 'Undocumented' 5 'User id is not valid' 6 'Undocumented' 7 'The login being used is disabled' 8 'Incorrect password' 9 'Invalid password' 10 'Related to a SQL login being bound to Windows domain password policy enforcement. See KB925744.' 11-12 'Login valid but server access failed' 16 'Login valid, but not permissioned to use the target database' 18 'Password expired' 27 'Initial database could not be found' 38 'Login valid but database unavailable (or login not permissioned)' More detailed information is available in Aaron Bertrand's blog. share|improve this answer edited Dec 1 '12 at 13:27 answered Nov 30 '12 at 16:33 Pete Oakey 2841210 5 A LOT more details on these states (and several more states covered) in my blog post from last year: sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/… –Aaron Bertrand♦ Nov 30 '12 at 17:04 add a comment| up vote 0 down vote Here is what I found when I resolved this error: I had
Related Tips: More > Error Logs Problem SQL Server Error Logs often show a message related to error 18456. Although it generally means a sql server error 18456 severity 14 state 58 login attempt from a client connection has failed, different State numbers associated
Error 17187 Severity 16 State 1
with the error can mean different reasons for the failure. One of the error States is 38, which sql error 18456 severity 14 state 5 was added with SQL Server 2008, means the database being accessed cannot be found or does not exist. Unfortunately the Error Log entry does not show what database it is, http://dba.stackexchange.com/questions/29613/login-failed-for-user-error-18456-severity-14-state-38 so in this tip we walk through how you can determine which database is causing the error message. Solution A few days ago I was looking through the Error Log of a database server and noticed a large number of the same error messages that looked like the following: 2011-12-15 11:22:08.76 Logon Error: 18456, Severity: 14, State: 38. 2011-12-15 11:22:08.76 Logon https://www.mssqltips.com/sqlservertip/2581/sql-server-error-18456-finding-the-missing-databases/ Login failed for user '
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked https://social.technet.microsoft.com/Forums/en-US/fe709703-9def-46fb-8455-8f76d0b7578d/login-failed-error-18456-severity-14-state-38?forum=sharepointadminprevious by: Login Failed Error: 18456, Severity: 14 State: 38 SharePoint > SharePoint 2010 - Setup, Upgrade, Administration and Operations Question 0 Sign in to vote I've done as much searching on the web as I can to try to find a solution to this error, however it seems that my error 18456 particular case is a bit more unique. We are running SharePoint 2010 with SQL 2008 R2. The error from the SQL log reports: 04/06/2012 09:39:54,Logon,Unknown,Login failed for user 'Domain\user1'. Reason: Failed to open the explicitly specified database. [CLIENT: