Installing a remote Operations Manager database with DBcreateWizard.exe

1 minute read

Hi all,

One of my customers was asking me if he could install the OpsMgr database remotely. This is perfectly possible with DBCreatewizard tool. The DBcreatewizard tool is a small tool that let you install the Opsmgr database and the datawarehouse without running the setupOM.exe wizard. Kevin Holman has blogpost on whether you should use the DBcreatewizard or just the good old setupOM.exe

 

By running the following command you can install the OperationsManager DB locally or remotely by specifying the severname:

DBCreateWizard.exe DBType:”Operations Manager Database” SQLInstance:OpsMgrSQserverLinfrontscomInstance DBName:OperationsManager ManagementGroup:OperationsManager UserGroup:InfrontscomOpsMgrAdmins AutoErrorReport DBCreate DBSize:5000 DBPath:”C:Program FilesMicrosoft SQL ServerMSSQL10.INFRONTSCOMDATA” LOGPath:”C:Program FilesMicrosoft SQL ServerMSSQL10.INFRONTSCOMMSSQLLog”

 

 image

 

And for the Datawarehouse run the following command:

DBCreateWizard.exe DBType:”Operations Manager Data Warehouse Database” SQLInstance:OpsMgrSQLserverinfrontscomInstance DBName:OperationsManagerDW AutoErrorReport DBCreate DBSize:500 DBPath:”C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATA” LOGPath:”C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLog”

 

In your local user temp folder C:Documents and SettingsuserLocal SettingsTemp1  you will find a log file each time you run the dbcreatewizard tool.

——————————————————————————–
Starting Logging for Setup.exe 13:19:14 dinsdag 4 januari 2011
——————————————————————————–
13:19: GetlocalSQLServerPath: caught an exception: Invalid namespace
13:19: GetlocalSQLServerPath: caught an exception: Invalid namespace
13:19: GetlocalSQLServerPath: caught an exception: Invalid namespace
13:19: GetlocalSQLServerPath: caught an exception: Invalid namespace
13:19: Creating database…
13:21: **Database created successfully.
** ——————————————————————————–
Finished Logging for Setup.exe 13:21:19 dinsdag 4 januari 2011
——————————————————————————–

Leave a comment