System Center Dynamics by wwwally

Installing SCOM 2007 R2 on SQL 2008 R2

Posted on 12 January, 2011. Filed under: SCOM 2007 |

Recently Microsoft added support for SQL 2008 R2 as a supported configuration for SCOM 2007 R2. With this support the normal installation path has changed a bit when SQL 2008 R2 is used as the Operations Manager database and the operations manager data warehouse database. Microsoft released a knowledge base article  (KB2425714) with the following steps to perform the installation.

High level steps for a new installation installing on SQL 2008 R2

1. Use the DBCreateWizard tool to install the OperationsManager database.
2. Install the first management server in the management group that was specified in step 1.
   For more information, see the System Center Operations Manager R2 Deployment guide.
   Important When you install the first management server, you should not install the Database component.

1. Use the DBCreateWizard tool to install the OperationsManagerDW database.
2. Install System Center Operations Manager 2007 R2 Reporting.
   1. On the SQL Server Reporting Services server, rename the local group SQLServerReportServerUser$<hostname>$MSSRS10_50.<SQLInstanceName> to SQLServerReportServerUser$<hostname>$MSSRS10.<SQLInstanceName>
   2. Install System Center Operations Manager 2007 R2 Reporting.
      Important When you install System Center Operations Manager 2007 R2 Reporting, you should not install the Data Warehouse component.
   3. Rename the local group SQLServerReportServerUser$<hostname>$MSSRS10.<SQLInstanceName> back to original name SQLServerReportServerUser$<hostname>$MSSRS10_50.<SQLInstanceName>

Beside better performance here is a top 10 why to use SQL 2008 R2 in stead of SQL 2008.

Regards,
Walter Eikenboom
http://systemcenterdynamics.wordpress.com

Make a Comment

6 Responses to “Installing SCOM 2007 R2 on SQL 2008 R2”

Comments RSS Feed

Where's The Comment Form?