Error: 18456, Severity: 14, State: 38.

Question

Error: 18456, Severity: 14, State: 38.

ravishankar.yedoti

Right there with Babe

Points: 738
More actions
September 6, 2011 at 6:42 am

#243328

I am getting the below error on sql 2008. can some one help me with this. This msg pops up every 1 min in the errorlog.
Logon Error: 18456, Severity: 14, State: 38.
Logon Login failed for user ''CORP\s-pspadmin'. Reason: Failed to open the explicitly specified database
but this login has permissions and he is the owner of the database

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Check if the user has access to master.

It's most likely a monitoring app or service that doesn't specify the 3rd party db in the connection string and then does use db or select db.dbo.table.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 2

Here is another case with the same Domain having the same problem. This is bad news. As per blog by MSDN, any error state higher than 18 might require help from CSS. Check this blog out.

-Roy

ravishankar.yedoti Right there with Babe Points: 738 More actions · Answer 3

how to check ... whether he has access to master or not

by using sp_helplogins or what

ravishankar.yedoti Right there with Babe Points: 738 More actions · Answer 4

ravishankar.yedoti (9/6/2011)
I am getting the below error on sql 2008. can some one help me with this. The domain account is a sysadmin on the server. This msg pops up every 1 min in the errorlog
Logon Error: 18456, Severity: 14, State: 38.
Logon Login failed for user ''CORP\s-pspadmin'. Reason: Failed to open the explicitly specified database

his login is exist and he is the owner of the db

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 5

Roy Ernest

SSC-Dedicated

Points: 38780

September 6, 2011 at 10:23 am

#1377559

Did you check the blog I posted?

-Roy

Suresh B. SSC-Insane Points: 22986 More actions · Answer 6

ravishankar.yedoti (9/6/2011)
ravishankar.yedoti (9/6/2011)
I am getting the below error on sql 2008. can some one help me with this. The domain account is a sysadmin on the server. This msg pops up every 1 min in the errorlog
Logon Error: 18456, Severity: 14, State: 38.
Logon Login failed for user ''CORP\s-pspadmin'. Reason: Failed to open the explicitly specified database
his login is exist and he is the owner of the db

Problem is in the connection string used by a client application.

Run Profiler to find the client IP and process id.

Then login to that client machine and the check the process id in Task Manager.

After you identified the client application, fix it.

BTW, are all the databases online?

Is any database removed recently?

ravishankar.yedoti Right there with Babe Points: 738 More actions · Answer 7

thanks a lot suresh, and can u give some more information on this issue

like

what event i need to select in profile. to trace this information

Suresh B. SSC-Insane Points: 22986 More actions · Answer 8

Select events Error Log, Event Log under Errors and Warnings and Audit Login Failed under Security Audit