Ying Li(MVP) at myITforum.com

PowerShell & System Center

To set up the Data Warehouse database using the Database Configuration Wizard - SCOM SP1

To set up the Data Warehouse database using the Database Configuration Wizard

1.   Create a new directory on the database server.

2.   Copy the file DBCreateWizard.exe from the following directories on the installation media:

 \SupportTools\DBCreateWizard.exe

3.   From a computer with the Operations Manager 2007 Operations Console installed, copy the following files to the directory you created on the database server:

·      C:\Program Files\System Center Operations Manager 2007\ Microsoft.EnterpriseManagement.UI.ConsoleFramework.dll

·      C:\Program Files\System Center Operations Manager 2007\ Microsoft.MOM.UI.Common.dll

·      C:\Program Files\System Center Operations Manager 2007\ Microsoft.MOM.UI.Wrappers.dll

4.   Double-click DBCreateWizard.exe to run the wizard.

5.   On the Welcome page, click Next.

6.   On the Database Information page, select to create a Data Warehouse Database.

7.   Select the instance on which to install.

8.   Specify a unique name or accept the default. It is recommended to accept the default.

Note

If you specify a custom name for the Data Warehouse database, be sure not to include a '-' character. The database installation will fail if a '-' character is included in the name.

1.   Specify a database size.

2.   Click Next.

Note

For a Data Warehouse, the installation skips to the Summary page.

3.   Specify a domain security group which has the Operations Manager Administrators, and then click Next to continue.

4.   On the Error Reporting page, choose to send error reports, and then click Next to continue.

5.   Review the Summary page, and then click Finish.

Posted: Mar 13 2008, 12:46 AM by yli628 | with 1 comment(s)
Filed under:

Comments

Ying Li at myITforum.com said:

We have a SCOM 2007 environment and initially it was a one server (RMS, OpsDB)environment. We upgraded

# March 17, 2008 6:06 PM