Cannot Configure the Administration Database

When configuring Commerce Server 2009 R2 by using the Commerce Server Configuration Wizard, the Administration database (MSCS_Admin) configuration screen displays an error message starting with "Execution of the TSQL command," and you cannot continue.

To resolve this issue, do the following:

  • Verify that the SQL Server agent service is running on the computer that is running SQL Server.

  • If you are starting a new installation of Commerce Server 2009 R2, and you have used SQL Server Management Studio to verify that no MSCS_Admin or DirectMailer database exists on the server that is running SQL Server, verify that the SQL Server Data folder does not contain the following files:

    • Mscs_admin.mdf

    • Mscs_admin.ldf

    • Directmailer.mdf

    • Directmailer.ldf

  • Verify that you have purchased enough licenses for your SQL Server installations.

  • Verify that you are not using a pre-release version of SQL Server.

See Also

Other Resources

Commerce Server 2009 R2 Troubleshooting