Error After Move the Monitoring DB to other SQL Server

[Daniel_R_]

Hi Guys,

Recently i moved Directory, Monitoring and VaultStore Databases to other SQL server without problems (all services and task are working fine), but now..... when i access to "Enterprise Vault Operations Manager" i only can see the next message "An error has occured" in all tabs.  I have EV7.0 SP1 with Win 2k3 SP1

Errors in the event log:

Event Type: Error
Event Source: Enterprise Vault
Event Category: Monitoring Configuration Utility
Event ID: 41123
Description:
Monitoring Configuration Utility reported error: Monitoring database was not found.

Event Type: Error
Event Source: Enterprise Vault
Event Category: Monitoring Configuration Utility
Event ID: 41122
Description:
Monitoring Configuration Utility completed unsuccessfully. Exit code UpgradeError(21). Additional info: Upgrade failed

Can anyone tell me how could fix this issue?

Thanks for your help
Dany

[TonySterling]

You could try this technote:

http://support.veritas.com/docs/287930

[Daniel_R_]

Thanks Tony,

well i have tried the Technote without results,  The problem is that EV Operations Manager looks the SQL server old.

[TonySterling · Accepted solution]

In the EnterpriseVaultDirectory database there is a table called MonitoringSettings. 

You might need to update the SQLSever column to reflect the new server name.

[Daniel_R_]

Hey Tony Thank you very much !!

Your answer solved my issue.   It should be in Technote "How to move an EV directory and store databases from one SQL server to another"