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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics