Error Messages Occur When You Install Commerce Server and SQL Data Directory Contains Unattached MDF/LDF Files (272092)
The information in this article applies to:
- Microsoft Commerce Server 2002
- Microsoft Commerce Server 2000
This article was previously published under Q272092 SYMPTOMS
When you install Commerce Server, the following error messages may occur:
Commerce Server 2000 WARNING: A failure occurred in ExecTSQLCommand() on
d:\cs40\private\cs40\...\database.cpp:603. The error description is:
Execution of the TSQL command "CREATE DATABASE MSCS_Admin" failed with error
code -2147217900.
Commerce Server 2000 WARNING: A failure occurred in
CA_PRED_InstantiateResource() on
d:\cs40\private\cs40\setup\ca_dll\predictor.cpp:49. The error code
is -2147418113, and the description is: Catastrophic failure
Commerce Server 2000 WARNING: A failure occurred in ExecTSQLCommand() on
d:\cs40\private\cs40\...\database.cpp:603. The error description is:
Execution of the TSQL command "CREATE DATABASE DirectMailer" failed with
error code -2147217900.
Commerce Server 2000 WARNING: A failure occurred in
CA_DML_InstantiateResource() on
d:\cs40\private\cs40\setup\ca_dll\dml.cpp:020. The error code
is -2147418113, and the description is: Catastrophic failure
Error 1705. A previous installation for this product is in progress. You must undo the changes made by that installation to continue. Do you want to undo those changes?
CAUSE
This is caused by pre-existing Mscs_admin.mdf and Mscs_admin.ldf files in the SQL\Data directory. This can occur in a dual boot situation, or if the databases are not attached at the time of installation.
WORKAROUND
To successfully install Commerce Server, delete the Mscs_admin.mdf, Mscs_admin.ldf, Directmailer.mdf, and Directmailer_log.ldf files.
Important: Before you delete the .mdf and .ldf files, verify that the databases do not exist in Microsoft SQL Enterprise Manager.
| Modification Type: | Major | Last Reviewed: | 10/24/2003 |
|---|
| Keywords: | kbpending kbprb KB272092 |
|---|
|