Managing the Administration Database
Your Commerce Server 2002 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.
.gif "Ee810053.note(en-US,CS.20).gif")
Note
- All Commerce Server computers can use a single Administration database. 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:
- Interaction Between Sites and the Administration Database
- Managing Security on the Administration Database
- Changing the Administration Database Connection String
Copyright © 2005 Microsoft Corporation.
All rights reserved.