Configuring the Internal Database Server
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
This topic provides information about the test tier database server in a Commerce Server 2007 enterprise deployment. This server contains the databases for the test Web server, and provides a safe environment where internal users can test site updates without affecting the run-time services in the production environment. After the updates are approved, you can stage the data to the database server in the staging environment in preparation for run-time publishing.
You can use Commerce Server with a database server that is running SQL Server 2005 with Service Pack 2, or SQL Server 2000 with SP4.
Follow these steps to configure the internal database server:
Install all prerequisite software. See What Are the Software Deployment Requirements?
Configure the network adapters. See Configuring the Network Adapters.
Join the database server to the domain. For more information, see the Windows Server 2003 Help or Windows Server 2008 Help.
Install the appropriate version of SQL Server on the database server. Choose one of the following:
SQL Server 2005 with SP2. See How to Install SQL Server 2005 and How to Install SQL Server 2005 Service Pack 2.
SQL Server 2000 with SP4. See How to Install SQL Server 2000 and How to Install SQL Server 2000 Service Pack 4.
Configure your SQL Server database by using the appropriate accounts and roles. See How to Associate Database Accounts with Database Roles.