Error 18456 Sql Server 2008 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 error 18456 sql server 2008 windows authentication Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Microsoft Sql Server Error 18456 Sql 2008 R2
or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is sql server error 18456 severity 14 state 5 a question and answer site for database professionals who wish 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 microsoft sql server error 18456 state 1 works: Anybody can ask a question Anybody can answer The best answers are 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
Microsoft Sql Server Error 18456 State 11
specified database My Question: Is there a list somewhere of all the variations of the 18456 errors (Login failed), for 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
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted microsoft sql server 2005 error 18456 the ability to create new threads on these forums. SQL Server Forums Profile microsoft sql server error 18456 login failed for user | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot
Microsoft Sql Server Error 18456 Linked Server
your Password? All Forums SQL Server 2008 Forums Other SQL Server 2008 Topics error: 18456, severity: 14, state: 38 Reply to Topic Printer Friendly Author Topic LawnMowerPros Starting Member USA 9 Posts http://dba.stackexchange.com/questions/29613/login-failed-for-user-error-18456-severity-14-state-38 Posted-03/06/2009: 23:06:31 I'm using SQL Server Express 2008 and I keep seeing this error (error: 18456, severity: 14, state: 38) in my log files. The error repeats many, many, many times and then the database goes into recovery mode. Can someone tell me what the error means?ThanksH and H Lawncare Equipmenthttp://www.LawnMowerPros.com guptam Posting Yak Master Canada 161 Posts Posted-03/06/2009: 23:25:40 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121202 State 38 means user doesn't have access to database it is trying to connect to.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ LawnMowerPros Starting Member USA 9 Posts Posted-03/06/2009: 23:33:40 Thank you Mohit. I'm accessing the server using Classic ASP, what should I set the permission level to?Thanks Again.H and H Lawncare Equipmenthttp://www.LawnMowerPros.com guptam Posting Yak Master Canada 161 Posts Posted-03/07/2009: 02:46:54 What is your connection string? In your Connection string what ever database you have there user must have access to be able to at least read in that database. Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ LawnMowerPros Starting Member USA 9 Posts Posted-03/07/2009: 18:04:50 My connection string is:Dim objConnSet objConn = Server.CreateObject("ADODB.Connection")objConn.ConnectionString = "Provider=SQLOLEDB;server=SERVER;database=DATABASE;uid=USERNAME;pwd=PASSWORD;"objConn.OpenI need read, write, delete. In the SQL Server Mangement screen I actually have permissions set to sysadmin. So I'm confused why I'd be getting the State 38 error.Thank you for your help.H and H Lawncare Equipmenthttp://www.LawnMowerPros.com guptam Posting Yak Master Canada 161 Posts Posted-03/07/2009: 18:29:25 Your "USERNAME" is sysadmin on server and you are getting th
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error: 18456, Severity: 14, State: 38. Login failed for user '****'. Reason: Failed to open https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a2af6e15-3d3c-4be7-8f4f-1c616bf74d7c/error-18456-severity-14-state-38-login-failed-for-user-reason-failed-to-open-the?forum=sqldataaccess the explicitly specified database. SQL Server > SQL Server Data Access Question 0 Sign in to vote Is it Possible to Obtain that Database Name which was specified explicitly on this login failure? Just want to know about that database name. Is it possible? Curious... PGupta Friday, April 18, 2014 9:30 AM Reply | Quote Answers 0 Sign in to vote You need to trace error 18456 the server using SQL Server Profiler Trace. Refer http://mssqltalks.wordpress.com/2013/02/25/how-to-audit-login-to-my-sql-server-both-failed-and-successful/ It seems like the the error that you are refering is from SQL serverlog. Regards, RSingh Edited by Ch. Rajen Singh Friday, April 18, 2014 11:10 AM Marked as answer by Fanny LiuMicrosoft contingent staff, Moderator Monday, April 28, 2014 9:35 AM Friday, April 18, 2014 11:05 AM Reply | Quote 0 Sign in to vote Yes, microsoft sql server it is from the sql server log. Profiler trace will tell about the events which ocured during trace run. But I want to know that is it possible to know about the database for which login has failed already? perhaps I am not vague. PGupta Try the below link, it would help you to identify the database: http://www.mssqltips.com/sqlservertip/2581/sql-server-error-18456-finding-the-missing-databases/ Proposed as answer by Prashanth Jayaram Friday, April 18, 2014 2:54 PM Marked as answer by Fanny LiuMicrosoft contingent staff, Moderator Monday, April 28, 2014 9:35 AM Friday, April 18, 2014 12:20 PM Reply | Quote All replies 0 Sign in to vote You need to trace the server using SQL Server Profiler Trace. Refer http://mssqltalks.wordpress.com/2013/02/25/how-to-audit-login-to-my-sql-server-both-failed-and-successful/ It seems like the the error that you are refering is from SQL serverlog. Regards, RSingh Edited by Ch. Rajen Singh Friday, April 18, 2014 11:10 AM Marked as answer by Fanny LiuMicrosoft contingent staff, Moderator Monday, April 28, 2014 9:35 AM Friday, April 18, 2014 11:05 AM Reply | Quote 0 Sign in to vote Yes, it is from the sql server log. Profiler trace will tell about the events which ocured during trace run. But I want to know t