Error 18456 on the RMS
Hello,
I am seeing these errors:
Log Name: Application
Source: MSSQLSERVER
Date: 5/19/2011 2:52:12 PM
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: AD\SVCMOMAction
Computer: OPMGRRMS1
Description:
Login failed for user 'AD\SVCMOMAction'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.32.188.34]
AND
Log Name: Application
Source: MSSQLSERVER
Date: 5/19/2011 2:52:11 PM
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: AD\SVCMOMDWA
Computer: OPMGRRMS1.
Description:
Login failed for user 'AD\SVCMOMDWA'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.32.188.28]
on the RMS but the SQL Team is telling me there is no SQL correlated event in SQL logs !!! ... where could I look for more info...
http://www.eraofdata.com/blog/sql-18456-login-failures/.
Thanks,
DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
May 19th, 2011 6:06pm
Hello,
I find out one Management Server registry were not changed after the migration of the database to the enterprise cluster.
38
Login valid but database unavailable (or login not permissioned)
The MS was still looking for the old DB Host.
Thanks,
Dom
System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 7:02pm


