SQL Server 2008 R2 can support SCOM 2007 R2 ??? Now , i can say "Yes"

  • Article

    Hi all :

    SQL Server 2008 R2 is release over 1 year . Before , you can't using SQL Server 2008 R2 as SCOM 2007 R2 's datebase directly, but now , you can !

    So , how can we do that ?

    First , you need to install SQL Server 2008 R2 standard or Enterprise , if you need SCOM 2007 R2 reporting , don't forget install SSRS .

    On this DB Server , insert SCOM 2007 R2 image , find and run DBCreatWizard.exe tool

    Display database configuration wizard

     Next , under Database Information , you can select database type , now we need create Operations Manager Database firstly ,fill in SQL Port and Db name and size .

   Next , under Management Group Configuration , you can assign MG name , and permission .

    Next , in Summary , you can check previous configuration

 

     if OK , Finish to create till display successfully .

 Secondly , using again this tool to create Operations Manager DW database

     Next till to finish. Now , you can review two db in this

    OK , you can starting install SCOM 2007 R2 . When you Installing SCOM 2007 R2 first Management Server . you need pay attention , don't choose Database item 

    When you install SCOM 2007 R2 Reporting ,

     a. On the SQL Server Reporting Services server, rename the local group SQLServerReportServerUser$<hostname>$MSSRS10_50.<SQLInstanceName> to SQLServerReportServerUser$<hostname>$MSSRS10.<SQLInstanceName>

      b. 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.

       c. Rename the local group SQLServerReportServerUser$<hostname>$MSSRS10.<SQLInstanceName> back to original name SQLServerReportServerUser$<hostname>$MSSRS10_50.<SQLInstanceName>

OK , You will successfully complete the installation.

Enjoy !

Justin Gao

Microsoft (China)