How to Configure a Database Server

  • Article

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:

  • Non-clustered database server that is running SQL Server 2005 with Service Pack 2 (SP2) or SQL Server 2008.

  • Clustered database server that is running SQL Server 2005 with SP2 or SQL Server 2008

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 2009 through the Windows Server System (WSS) VSS framework. For conceptual information, see 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 with SP2

  1. Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.

  2. Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008.

  3. Install SQL Server 2005 with SP2 on the database server. For more information, see How to Install SQL Server 2005.

    To install a Commerce Server 2009 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

  4. 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 with SP2

  1. Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.

  2. Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008 Help.

  3. Install SQL Server 2005 with SP2 on the database server. For more information, see https://go.microsoft.com/fwlink/?LinkId=71364.

    To install a Commerce Server 2009 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

  4. Configure the service principal name. For more information, see How to Configure the Service Principal Name.

  5. Install the Microsoft Distributed Transaction Coordinator (MSDTC) resource. For more information, see https://go.microsoft.com/fwlink/?LinkId=56259.

To configure a non-clustered database server that is running SQL Server 2008

  1. Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.

  2. Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008.

  3. Install SQL Server 2008 on the database server. For more information, see How to Install SQL Server 2008.

  4. To install a Commerce Server 2009 production database server, select the following options on the Components to Install page of the SQL Server 2008 Installation Wizard:

    • SQL Server Database Services

    • Notification Services

    • Integration Services

    • Workstation components, Books Online, and development tools

  5. 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 2008

  1. Configure the database server network adapters. For more information, see How to Configure the Database Server Network Adapters.

  2. Join the domain on the database servers. For more information, see Windows Server 2003 Help or Windows Server 2008.

  3. Install SQL Server 2008 on the database server. For more information, see How to Install SQL Server 2008. For information about how to create a new SQL Server failover cluster, see https://msdn.microsoft.com/en-us/library/ms179530.aspx.

  4. To install a Commerce Server 2009 production database server, select the following options on the Components to Install page of the SQL Server 2008 Installation Wizard:

    • SQL Server Database Services

    • Notification Services

    • Integration Services

    • Workstation components, Books Online, and development tools

  5. Configure the service principal name. For more information, see How to Configure the Service Principal Name.

  6. Install the Microsoft Distributed Transaction Coordinator (MSDTC) resource. For more information, see https://go.microsoft.com/fwlink/?LinkId=56259.

See Also

Other Resources

Configuring the Database Servers

Configuring the Data Warehouse and Analysis Server