Operations Manager 2007 R2 does not show the active alerts, and error is sometimes the console Microsoft.EnterpriseManagement.Common.ServerDisconnectedException

The info file is not appropriate and thoughtful reading: CU5 after the patch, you must manually run two SQL scripts.

Manual operations that must be performed after you update the root management server and Data Warehouse.

This update contains fixes that must be manually applied. These fixes are applied by running the \SQLUpdate\CU5_DataWarehouse.sql file against the Operations Manager data warehouse (OperationsManagerDW) and by running the \SQLUpdate\CU5_Database.sql file against the Operations Manager database (OperationsManager).

To do this, follow these steps:

  1. Log on to the computer that hosts the Operations Manager 2007 database by using a user account that has database system administrator (SA) rightsto the Operations Manager 2007 database instance. To perform the database update remotely, log on to a computer that hosts SQL ServerManagement Studio by using a user account that has the appropriate SA rights to the Operations Manager 2007 database.
  2. Run SQL Server Management Studio.
  3. In the Connect to Server dialog box, connect to the instance of SQL Server that hosts the Operations Manager database. The default database name is OperationsManager.
  4. Click New Query on the toolbar.
  5. From the SQL Editor toolbar, use the Available databases option to select the Operations Manager database.
  6. On the File menu, click Open, select the \SQLUpdate\CU5_Database.sql file that was extracted by the Windows installer (.msi file), and then click Open.
  7. When the file is loaded, click Execute in the SQL Editor toolbar.
  8. For the Operations Manager data warehouse, repeat steps.However, connect to the instance of SQL Server that hosts the Operations Manager data warehouse, and then run the \SQLUpdate\CU5_DataWarehouse.sql file.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s