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?