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()
Hello, we tried this and received the error "DbCreate wizard.exe has stopped working"
Hi Michael,
What does your dbCreateWiz log say? It should be in %temp%.
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.