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
Date: 10/14/2009 2:09:38 PM
Event ID: 1
Task Category: None
C:\ISO\OpsMgr 2007 R2\DBCreateWizard.exe
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)
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.