Managing the Administration Database
Your Commerce Server 2000 site may consist of multiple computers, however, the configuration data for the resources for all computers is stored centrally in a single SQL Server Administration database named MSCS_Admin. This database is created automatically when you first install Commerce Server. During Setup, you must specify the SQL Server computer for the Administration database.
When you install Commerce Server on additional computers, you point the computers to the Administration database during Setup. By setting up all the computers to point to this central database, you can manage all the Commerce Server computers from a central console.
- A single Administration database can be used by all Commerce Server computers. Alternatively, each computer can use its own Administration database.
The following table shows the typical location of the Administration database in different environments.
|Type of environment||Typical location of Administration database|
|Single server containing Commerce Server, Microsoft SQL Server, and all Web components||On the single server|
|One or more Web servers and one database server||On the SQL Server computer|
|Multi-tier, multi-server environment||On one of the SQL Server computers (for optimal performance, separate from the Data Warehouse)|
This section contains:
- Configuring the Administration Database
- Interaction Between Sites and the Administration Database
- Managing Security on the Administration Database
All rights reserved.