Came across an issue today that was really just a matter of me not reading the fine print. I figured a quick post on this could help someone with the same issue.
While attempting to install a database using DBCreateWizard, I was receiving the following error.
Description: Stopped working
Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: dbcreatewizard.exe Problem Signature 02: 6.0.4900.0 Problem Signature 03: 4a05048f Problem Signature 04: System.Data Problem Signature 05: 220.127.116.11 Problem Signature 06: 49cc5a57 Problem Signature 07: 2481 Problem Signature 08: 2c Problem Signature 09: System.Data.SqlClient.Sql OS Version: 6.0.6002.2.2.0.274.10 Locale ID: 1033
Read our privacy statement: http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409
I was installing an operational database for a second Management Group in an instance already containing an operational database, so I attempted to name the database OperationsManager-MG2.
Note: It’s not recommended to host more than one OperationsManager database on a single instance in most environments. Usually this would be done in a lab or development environment.
Name the new database OperationsManagerMG2.
After research most every avenue, I popped open the deployment guide to see if there was anything I was missing about DBCreateWizard. I didn’t find anything directly pertaining to DBCreateWizard, but after further reading I had a memory refresh.
Page 103, number 12, of the R2 Deployment Guide states, “…do not insert a ‘-‘ in the database name…”. Doh!
I do not moderate this blog anymore. If you have a question regarding this post, send me a message.