Tuesday, August 7, 2007

Error getting state of database

Rarely am I moved to make a tech contribution after solving a tricky technical problem, mostly because the solution is already out there you just need to let your fingers do the walking via Google. But recently I came across a problem whose solution had a very faint Internet footprint so I decided to add another record for the search engines to index to hopefully help out a developer who might also be flummoxed by the same MCMS2002 SP2 hotfix problem.

After applying the post SP2 MCMS2002 hot fix the "Database Configuration Application" produced the following error. "Unable to query the condition of the selected database. The selected database may be corrupt. Please select either an existing MCMS database or an empty database. Automation error -2147221101"
The solution to this problem was to overwrite the local "_dca.ini" (found in "C:\Program Files\Microsoft Content Management Server\Server\Setup Files\SQL Install") file with the copy on the server containing the MCMS Database and MCMS installation.
This article (http://support.microsoft.com/?kbid=913401) basically contains the solution I used but it describes the solution for a different error message.

1 comment:

Anonymous said...

Thanks. This post helped me. Thanks again!