Login failure
-
Hi All,
Please let me know how we can track, for which database does user is connectiong :
--------------------------------------------------------------------------------------
2011-09-04 19:01:01.790 Logon Error: 18456, Severity: 14, State: 38.
2011-09-04 19:01:01.790 Logon Login failed for user 'CORP\shilpa'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.253.11.114]
2011-09-04 19:01:31.790 Logon Error: 18456, Severity: 14, State: 38.
2011-09-04 19:01:31.790 Logon Login failed for user 'CORP\shilpa'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.253.11.114]
2011-09-04 20:00:02.040 Logon Error: 18456, Severity: 14, State: 38.
--------------------------------------------------------------------------------------
-
the default database assigned to the login CORP\shilpa was dropped; change it to master adn try to log in again.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
But Default database is assigned to MASTER db itself.
-
In that case, it'll be the database name specified in the connection string passed by the application. You have the IP address of the computer the connection was made from; go to that and find out how the application is configured. If you can't do that, you may be able to run a Profiler trace to find out what database is being specified, although I've never tried getting that information myself, so I don't know whether it'll work.
John
-
Please let me know how i can get the previous info if i enable my profiler now?
-
As I said, I've never tried it myself, so it's up to you to experiment. Start with the events in the Security Audit section.
John
-
im not able to solve by profiler, is there any other try to find out the above issue???
-
You need to do as John suggested.
The following link is a step by step tutorial.
http://www.techrepublic.com/article/step-by-step-an-introduction-to-sql-server-profiler/5054787
Based on the error message it appears that you are attempting to open a Database Client.
Does the user have permissions to that database?
Good luck.;-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ -
Error State 38 is pretty rare. This could be because of some internal error. If you look at this blog from MSDN, you will read that you might require help from CSS to solve any error state above 18.
I hope it is not too severe. Best of luck.
-Roy
-
shilpa.shankar87 (9/5/2011)
im not able to solve by profiler, is there any other try to find out the above issue???Please take a look at this blog. It may help you.
-
What happens if you log on via SSMS?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply