Cannot Reinstall Commerce Server to Create a New Administration Database
If you cannot reinstall Commerce Server 2009 R2 to create a new Administration database, you must roll back to a previous Administration database or create a new Administration database. The Repair mode in the Commerce Server 2009 R2 Setup utility does not create a new Administration database.
To resolve this issue, create a new Commerce Server 2009 R2 Administration database named MSCS_Admin, and run the admin_schema.sql and admin_schema_increment.sql scripts. When you run the scripts, the system populates the schema of the Administration database but does not create any resources. After you run the scripts, you must unpack your site again.
.gif "Important note") Important Note: |
|---|
Prior to performing these steps, backup all Web site and Web service files and databases. |
Step 1: Create a new Commerce Server Administration database
Step 2: Populate the schema in the Administration database
Step 3: Unpack the Commerce Server site
Step 1: Create a new Commerce Server Administration database
To create a new Administration database in SQL Server
Click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
In Management Studio, connect to your SQL Server, and then in the Object Explorer, expand the nodes to the following path: <SQL Server name>/Databases.
Right-click Databases, and then click New Database.
In the New Database dialog box, on the General page, in the Database Name box, type MSCS_Admin, click Add, and then click OK.
Step 2: Populate the schema in the Administration database
To run the admin_schema.sql script in SQL Server
On the computer that is running SQL Server, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio
In the Connect to Server dialog box, click Options.
On the Connection Properties tab, in the Connect to database drop-down list, click <Browse server>.
In the Browse for Databases dialog box, click Yes.
In the Browse Server for Database dialog box, select the user database MSCS_Admin, and then click OK.
In the Connect to Server dialog box, click Connect.
On the File menu, click Open, and then click File.
In the Open File dialog box, browse to the folder <Commerce Server root>, where you installed Commerce Server.
Select the script file admin_schema.sql, and then click Open.
Click Execute on the toolbar.
Repeat steps 7 to 10 for the admin_schema_increment.sql script.
Step 3: Unpack the Commerce Server site
After you re-create the Administration database, unpack the site and Web services (see How to Unpack a Site for instructions) and restore any modified files and databases as needed.