Installing a remote Operations Manager database with DBcreateWizard.exe

11:56 am in Uncategorized by alkin

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:OpsMgrSQserverL\infrontscomInstance DBName:OperationsManager ManagementGroup:OperationsManager UserGroup:Infrontscom\OpsMgrAdmins AutoErrorReport DBCreate DBSize:5000 DBPath:"C:\Program Files\Microsoft SQL Server\MSSQL10.INFRONTSCOM\DATA" LOGPath:"C:\Program Files\Microsoft SQL Server\MSSQL10.INFRONTSCOM\MSSQL\Log"

 

 image

 

And for the Datawarehouse run the following command:

DBCreateWizard.exe DBType:"Operations Manager Data Warehouse Database" SQLInstance:OpsMgrSQLserver\infrontscomInstance DBName:OperationsManagerDW AutoErrorReport DBCreate DBSize:500 DBPath:"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA" LOGPath:"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log"

 

In your local user temp folder C:\Documents and Settings\user\Local Settings\Temp\1  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
——————————————————————————–