How to Configure a Database Server
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
This topic describes the sequence of tasks to follow when configuring a database server. Procedures are provided for the following four types of database server configurations:
Nonclustered database server that is running SQL Server 2005 with Service Pack 2.
Non-clustered database server that is running SQL Server 2000 with SP4.
Clustered database server that is running SQL Server 2005 with SP2.
Clustered database server that is running SQL Server 2000 with SP4.
Note
To configure the Data Warehouse and analysis server, see Configuring the Data Warehouse and Analysis Server.
As an optional step, you can start the Commerce Server Volume Shadow Copy Writer Service (VSS). This service provides extra functionality for the backup and restoration of Commerce Server through the Windows Server System (WSS) VSS framework. For conceptual information, see Commerce Server Volume Shadow Copy Writer Service. For information about how to start VSS, see How to Start the Commerce Server Volume Shadow Copy Writer Service.
To configure a non-clustered database server that is running SQL Server 2005
Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.
Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008.
Install SQL Server 2005 with SP2 on the database server. For more information, see How to Install SQL Server 2005 and How to Install SQL Server 2005 Service Pack 2.
To install a Commerce Server production database server, select the following options on the Components to Install page of the SQL Server 2005 Installation Wizard:
SQL Server Database Services
Notification Services
Integration Services
Workstation components, Books Online, and development tools
Configure the service principal name. For more information, see How to Configure the Service Principal Name.
To configure a non-clustered database server that is running SQL Server 2000
Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.
Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008 Help.
Install SQL Server 2000 with SP4 on the database server. For more information, see https://go.microsoft.com/fwlink/?LinkId=7200 and https://go.microsoft.com/fwlink/?LinkId=56.
Configure the service principal name. For more information, see How to Configure the Service Principal Name.
To configure a clustered database server that is running SQL Server 2005
Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.
Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008 Help.
Install SQL Server 2005 software on the database server. For more information, see https://go.microsoft.com/fwlink/?LinkId=7136.
To install a Commerce Server production database server, select the following options on the Components to Install page of the SQL Server 2005 Installation Wizard:
SQL Server Database Services
Notification Services
Integration Services
Workstation components, Books Online, and development tools
Configure the service principal name. For more information, see How to Configure the Service Principal Name.
Install the Microsoft Distributed Transaction Coordinator (MSDTC) resource. For more information, see https://go.microsoft.com/fwlink/?LinkId=5625.
To configure a clustered database server that is running SQL Server 2000
Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.
Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008 Help.
Set up the clustered database servers. For more information, see "SQL Server 2000 Failover Clustering" at https://go.microsoft.com/fwlink/?LinkId=7181.
Configure the service principal name. For more information, see How to Configure the Service Principal Name.
Install the MSDTC resource. For more information, see "How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 Cluster" at https://go.microsoft.com/fwlink/?LinkId=5625.