When you try installing SCOM 2007 R2 on top of SQL 2008 R2 for your database, it will give a Failed notifications like the following picture below:

image

According to this KB it can : http://support.microsoft.com/kb/2425714

So, here’s the step I’ve been working through, you have to create DB OpsMgr and OpsMgrDW from DBCreateWizard.exe, click Next

image

Choose the DB Type and DB Size, Next

image

Entry the Management Group name, click Next twice

image

Verify the Summary and click Finish

image

And your DB created successfully

image

Don’t forget continue with DB OpsMgrDW

image

If you open SQL Server Management Studio you will see two DB created Smile

image

This is important when you install SCOM, do not select the Database component

image

Before installing SCOM Reporting component, rename the local group : SQLServerReportServerUser$<hostname>$MSSRS10_50.<SQLInstanceName> to SQLServerReportServerUser$<hostname>$MSSRS10.<SQLInstanceName>

Same with installing SCOM Reporting, do not select Data Warehouse component

image

After finish the installation, Rename the local group SQLServerReportServerUser$<hostname>$MSSRS10.<SQLInstanceName> back to original name SQLServerReportServerUser$<hostname>$MSSRS10_50.<SQLInstanceName>

Advertisements