Running OpsMgr 2007 R2 DBCreateWizard on 64-bit SQL Server

There may be an issue when running the R2 64-bit DBCreateWizard on an SQL server.

You may see the following in the application log:

Log Name: Application
Source: Bid
Date: 10/14/2009 2:09:38 PM
Event ID: 1
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SQL01.domain.pvt
Description:
C:\ISO\OpsMgr 2007 R2\DBCreateWizard.exe
8880

Microsoft.EnterpriseManagement.UI.ConsoleFramework, Version=6.0.4900.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35

System.DllNotFoundException: Unable to load DLL ‘MOMBIDldr.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at Bid.internalInitialize()

Sponsors, article continues below...

The simple fix is to copy MOMBIDldr.dll from your (hopefully) 64-bit SCOM server to the directory where you copied the SupportTools\AMD64 to and run DBCreateWizard again.

If you are still having issues as I had then check your dbCreateWiz log file from %temp%.

My log file had the following
2:50 PM: CreateDB: Attempting to create OperationsManagerDW on USHUBSQLV14\WHSE_OPSMGR threw the following sql exception Directory lookup for the file “F:\DATA1\OperationsManagerDW.mdf” failed with the operating system error 3(The system cannot find the path specified.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors..
2:50 PM: Database creation failed. The database might have been incompletely created or modified.
2:50 PM: System.InvalidOperationException: An error occurred while trying to create the database on your SQL Server. Check your logs for more information.
at Microsoft.EnterpriseManagement.Setup.DBCreateWizard.Program.LaunchDBCreation()

This entry was posted in Microsoft, SCOM.

3 Responses to Running OpsMgr 2007 R2 DBCreateWizard on 64-bit SQL Server

  1. Michael says:

    Hello, we tried this and received the error "DbCreate wizard.exe has stopped working"

  2. Seth says:

    checking the %temp$ dir helps immensely. my issue was that i had already installed SCOM DB's once prior to this SQL server and they were still there. Just deleted them and I'm in business.

Leave a Reply to Stephen Cancel reply