If you have chosen to use SQL Server R2, SCOM 2007 R2 will not install correctly. You must create the Operations Manager database first. This document will help you create that database.
o Assuming you’ve installed everything correctly up to this point, The SCOM installer will guide you up to here:
o At this point, you would normally not have the database red X. When you click next, an error would stop you from continuing. The SCOM 2007 R2 installation wizard was not designed to support SLQ Server R2
Do one or more of the following:
1. Go to the directory where you have your SCOM install files and click on the Support Tools. There are three folders under this folder. Each folder has programs for the specific OS your currently running. In the case of 64bit, there is the AMD64 folder. Double click the appropriate folder. Once open, you will find DBCreateWizard.exe almost at the very top. Double Click on it. After the program is up and running, click next.
At this point, add 1433 for SQL Server and change the directory paths for the database.
WARNING: The ownership of the database by default will be the logged on user at the time it was created. You can change ownership later.
Click Next to continue.
If successful, the program will bring up a message box to that effect or, if it fails, it will tell you why.
When you’re done and you’re back into the install, click on the database and select: This component will not be available.
The setup program should continue running with an issue.