Configuring the Database Servers

  • Article

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This section provides instructions about how to deploy the database servers. You can deploy Commerce Server on single or clustered instances of SQL Server on either SQL Server 2005 with Service Pack 2 (SP2) or SQL Server 2000 with SP4.

When you install clustered instances of SQL Server, make sure that you follow the prescribed sequence for starting and restarting computers. Otherwise, data corruption may occur on the shared disks if multiple computers try to write to the same disk at the same time before you install Windows Clustering.

Before you start the SQL Server installation, make sure that you have completed the preinstallation steps in Configuring the Commerce Server Network and Configuring a Domain Controller.

Consider the following issues before you configure clustered SQL Server computers:

  • Do not connect the computers that are running SQL Server by using a crossover cable. Use a switch (or hub) instead to maintain connectivity during failover.

  • Use a storage area network (SAN), or two shared storage drives with four 9.0 gigabyte (GB) SCSI hard drives (configured as a single 25.0 GB RAID1 or RAID10 logical drive). Do not use RAID0 logical drives for lack of redundancy.

  • For the Windows Clustering network adapter only, do not disable NetBios over TCP/IP on the public interface, or you will be unable to add the second computer that is running SQL Server to the cluster. For all other network adapters, especially Internet-facing adapters, disable NetBios over TCP/IP as a security best practice.

To configure a database server, follow these steps:

  1. To set up the production database servers as either clustered or non-clustered instances, see How to Configure a Database Server.

  2. To set up the Data Warehouse and analysis server, see Configuring the Data Warehouse and Analysis Server.

  3. Make sure that you have enabled delegation for the database server on the domain controller. For more information, see How to Enable Delegation for All Computers Running SQL Server.

  4. Grant Commerce Server service identities access to the databases as needed.

    Note

    Perform this step only after you have installed the business management server or staging server in the corresponding tier and unpacked the Commerce Server site. Commerce Server databases are installed when you configure Commerce Server and unpack Commerce Server resources and Web services.

    This step is required for these database servers:

    • Production data tier database server

    • Staging database server

    • Internal/test database server

    • Data Warehouse and analysis server

    For more information, see Granting Access to the Commerce Server Databases.

In This Section