Configuring the Database Servers
This section provides instructions about how to setup the database servers in the data tier. You can deploy Commerce Server 2009 R2 databases on single or clustered instances of SQL Server 2008.
.gif "Important note") Important 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. |
Verify the following prerequisites before you configure the Commerce Server 2009 R2 database servers.
Domain controller configuration is complete, as required for your deployment environment.
Consider the following 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 set up the production database servers as either clustered or non-clustered instances, see How to Configure a Database Server.
Configure the Database Server Network Adapters. Each database server has one or two network adapters depending on the configuration of your network.
To set up the Data Warehouse and Analysis server, see Configuring the Data Warehouse and Analysis Server.
Enable delegation for the database server on the domain controller.
Grant Commerce Server 2009 R2 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 2009 R2 site. Commerce Server 2009 R2 databases are installed when you configure Commerce Server 2009 R2 and unpack Commerce Server 2009 R2 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 R2 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.