Error 18456 Login Failed 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 company Business Learn more
Sql State 28000 Error 18456 Login Failed
about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered sql state 28000 error 18456 login failed for user Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and
Error 18456 Login Failed For User Sa
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 voted up and rise to the top Login microsoft error 18456 login failed failed for user - Error: 18456, Severity: 14, State: 38 [duplicate] up vote 0 down vote favorite This question already has an answer here: Login failed for user - Error 18456 - Severity 14, State 38 2 answers I am trying to run and ADODB command in MS Access 2012 to exec a stored proc in our SQL server 2008R2 database, but I keep getting error 38 and SQL profiler shows the following: Error: 18456, Severity: 14, State: login failed error 18456 sql server 2008 r2 38. 2015-01-28 12:59:27.34 Logon Login failed for user 'NordenDevel'. Reason: Failed to open the explicitly specified database. [CLIENT: 82.71.5.169] This user (NordenDevel) login works on this database (NordenWeb) in SQL Server Management Studio and in Visual Studio, so the database is working fine and I do not see how it could be a permission issue. Can anyone suggest what I could do to find out what's wrong? Many thanks, YAOWSC sql-server-2008-r2 security logins share|improve this question edited Jan 29 '15 at 15:27 marc_s 5,41632743 asked Jan 28 '15 at 18:42 YAOWSC 111 marked as duplicate by Shawn Melton, Philᵀᴹ, RolandoMySQLDBA, Paul White♦, dezso Jan 29 '15 at 6:01 This question was marked as an exact duplicate of an existing question. 1 Check that login's default database - I bet it's not NordenWeb. Or, somehow, Access is specifying a different database. –Aaron Bertrand♦ Jan 28 '15 at 18:44 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote As mentioned by Aaron, you're login 'say' X would be pointing to a different database rather than NordenWeb, when it throws error with state 38: You need to check the login for any other mapped databases. To find correct error you need to enable the trace when above error is created: To dig in deep do nslookup 82.71.5.169 from windows to find the host name, just to verify we
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 the
Login Failed Error 18456 Sql Server 2012
ability to create new threads on these forums. SQL Server Forums Profile | login failed for user error 18456 sql server authentication ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password?
Login Failed For User Error 18456 Windows Authentication
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 Posted-03/06/2009: 23:06:31 http://dba.stackexchange.com/questions/90445/login-failed-for-user-error-18456-severity-14-state-38 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 State 38 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121202 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 that error? Hmm..Can you please confirm that w
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Login Failed Error: 18456, Severity: 14 State: https://social.technet.microsoft.com/Forums/en-US/fe709703-9def-46fb-8455-8f76d0b7578d/login-failed-error-18456-severity-14-state-38?forum=sharepointadminprevious 38 SharePoint > SharePoint 2010 - Setup, Upgrade, Administration and Operations https://justaprogrammer.net/2012/12/09/a-misleading-sql-error-message-error-18456-severity-14-state-38/ 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 particular case is a bit more unique. We are running SharePoint 2010 with SQL 2008 error 18456 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:
I had to help a client out with an error that kept appearing in their event logs: Login failed for user ‘domain\user'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.0.25] It took me a while to troubleshoot the error. The client's internal system administrator (who was quite sharp) only had to call me in in the first place because the error was a little misleading. See the first thing I did when I saw that was audit login failures. In the trace, the database was listed as master. The user had full access to master. However, I later learned that the user was switching from master to a non-existent database, which was triggering this error. I figured this out thanks to Sadequl Hussain‘s article, SQL Server Error 18456: Finding the Missing Databases. Sadequl explains in detail the how and the why. However, the take home is you need to trace for User Error Message to get the message that tells you what database you are connecting to. This took me about an hour to solve. Honestly, it was a bit humbling of an experience. It took me an hour to figure out something a full time senior DBA would probably be able to solve in 15 minutes. However, I'll probably be able to solve this error in 15 minutes myself go forward. Finally, the fact that it took me a while to find this one blog article that explained what the issue actually was proves how dependent I've become upon google. Tagged Microsoft SQL Server Post navigation The #MongoHelp twitter manifestoAnnouncing ILRepack-BuildTasks Search for: Recent Posts Giving back to #sqlfamily Microsoft, please open source sqlcmd, Sqlps, SMO, and LogParser The case for open sourcing the SQL Saturday Website Split testing using nginx proxy cache Creating a minimally viable Centos instance for SSH X11 Forwarding Tags#SQLAmtrak #sqlfamily .Net 2010 year in review Async Workflow Atlantis Interactive centos chocolatey command line console f# farmanager firing fsharpx git github HowTo javascript jQuery meta Microsoft Microsoft SQL Server mongodb MSBuild MySQL OLPC Open Source OSS path php PlaneDisaster.NET poshrunner PowerShell project euler ReactOS RedGate SQL SQL Saturday SQL Saturday 121 SVG System Administration Team Foundation Server Visual Studio WCF windows internals study group Archives March 2015 April 2014 November 2013 Ma