Configuring the Database Servers

Commerce Server 2009

This section provides instructions about how to deploy the database servers. You can deploy Commerce Server 2009 on single or clustered instances of SQL Server on either SQL Server 2005 or SQL Server 2008.

Dd451625.alert_caution(en-US,CS.90).gifImportant Note:

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 pre-installation 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.

  • 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 2009 service identities access to the databases as needed.


    Perform this step only after you have installed the business management server or staging server in the corresponding tier and unpacked the Commerce Server 2009 site. Commerce Server 2009 databases are installed when you configure Commerce Server 2009 and unpack Commerce Server 2009 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.

Data Warehouse Reports when Using SQL Server 2008

For the Commerce Server 2009 Data Warehouse sample reports to work correctly with SQL Server Reporting Services (SSRS) 2008, you must upgrade the report files (RDL files). To upgrade the reports, open them by using SQL Server Business Intelligence Development Studio 2008. The report files are located in the C:\<Commerce Server root>\RDLs folder.

After you do this, you can upload the upgraded reports to the server using the Report Manager or rs.exe utility. You must also create data sources to connect the reports to the required SQL Server Analysis Server. See the SQL Server 2008 documentation for detailed instructions.