Microsoft Commerce Server 2007 Installation and Configuration Guide
Microsoft Corporation
Published: May 2008
Abstract
This document provides an overview of the hardware, software, and security-enhanced configuration requirements for Microsoft Commerce Server 2007, and detailed instructions for installing and configuring Commerce Server on a single computer.
Contents
Installation and Configuration Guide for Microsoft Commerce Server 2007
In This Section
Commerce Server 2007 Component Overview
Pre-installation Requirements and Procedures
Hardware Requirements
Software Requirements
Microsoft Operating System and Web Server Software Requirements
Additional Prerequisite Software Requirements
Commerce Server Installation Considerations and Restrictions
Install Prerequisite Software
Create User Accounts
Set IIS to Use ASP.NET
Verify That SQL Server is Running
Commerce Server 2007 Installation Overview
Installing Commerce Server 2007
Configure Commerce Server 2007
Unpack the CSharp Site
Post-Configuration Procedures
Assign Write Permissions for Commerce Server Services
Add Users or Windows Groups to the Authorization Roles
Step 1: Create the Business Management administrator Windows groups
Step 2: Add users to the Business Management administrator Windows groups
Step 3: Add Windows groups to the administrator authorization roles
Step 4: Add CSLOB account to the authorization roles
Grant Web Applications and Window Services Access to the Databases
Step 1: Create SQL Server database accounts
Step 2: Associate the SQL Server database accounts with the database roles in SQL Server
SQL Database Account, Database, and Database Role User Mapping
Configure a Temporary SSL Certificate
Assign Permissions to the IIS Worker Process Groups
Step 1: Create application pools for the Web applications
Step 2: Configure the application pool accounts
Step 3: Add the worker process accounts to the IIS_WPG or IIS_IUSRS group
Step 4: Assign the applications to the application pools
Restart IIS and Verify That the Web Services Are Installed
Grant the Marketing Web Service Permission to Launch and Activate the Direct Mailer Service
Configure and Start the Commerce Server Health Monitoring Service
Configure and Start the Commerce Server VSS Writer Service
Install Commerce Server Business Management Applications
Install Commerce Server Adapters for BizTalk Server
Upgrade Requirements
Prepare to Upgrade to Commerce Server 2007 from Commerce Server 2000 or 2002
Commerce Server 2007 Upgrade Wizard
Uninstall Commerce Server 2007
Uninstall Commerce Server 2007
Remove the Commerce Server run-time objects and administration tools
Remove the Business Management Applications
Remove the Commerce Server client tools
Uninstall Commerce Server Adapters for BizTalk Server
Uninstall Commerce Server Web Sites
Delete the Commerce Server databases
Delete the Commerce Server site virtual directories
Delete the Commerce Server site folders and files
Troubleshoot Your Commerce Server Installation
Commerce Server cannot find the Administration database
Solution
Cannot configure the Administration database
Solution
Cannot reinstall Commerce Server to create a new Administration database
Solution
Step 1: Create a new Commerce Server Administration database
Step 2: Run the admin_schema.sql script
Step 3: Run the admin_schema_increment.sql script
Step 4: Unpack the Commerce Server site
BizTalk Server not functional after uninstalling Commerce Server
Solution
AuthFilter not functional after upgrading Commerce Server
Solution
Adapter installation failure on 64-bit computers: the ServicedComponent being invoked is not configured correctly
Solution
Unattended Installation Command Syntax Reference
How to Install Commerce Server by Using the Setup.exe Command Syntax for Unattended Installations
Setup.exe Command Syntax
How to Configure Commerce Server by Using the CSConfig.exe Command
CSConfig.exe Command Syntax
Sample Configuration XML File
Commerce Server Account, User Group, and Application Pool Requirements
General Accounts
Commerce Server Windows Services and Account Assignments
Commerce Server Site Account and Application Pool Assignments
Commerce Server Web Services and Account and Application Pool Assignments
Authorization Role-Based Access Control
Web Service Administrator Role Assignments
BizTalk Adapters Role Assignments
Commerce Server Health Monitoring Service Role Assignments
Installation and Configuration Guide for Microsoft Commerce Server 2007
Last updated: May 2008
Note
For the most current version of this document, see the Microsoft Download Center at Additionally, for known issues and important, late-breaking information, see the Microsoft Commerce Server 2007 SP2 Readme located at
This document provides an overview of the hardware, software, and security-enhanced configuration requirements for Commerce Server 2007, and detailed instructions for installing and configuring Microsoft Commerce Server 2007 on a single computer. For instructions about how to deploy Commerce Server 2007 on multiple computers, see
Note
If you are installing Commerce Server 2007 on a developer computer or for evaluation and want to minimize the security-related configuration procedures associated with installing Commerce Server 2007, then see the "Quick Installation Guide for Microsoft Commerce Server 2007" at
We strongly recommend that you read this document before you install Commerce Server 2007.
Note
All references to Commerce Server in this document, unless otherwise specified, are to Commerce Server 2007.
In This Section
Commerce Server 2007 Component Overview
Pre-installation Requirements and Procedures
Commerce Server 2007 Installation Overview
Installing Commerce Server 2007
Configure Commerce Server 2007
Unpack the CSharp Site
Post-Configuration Procedures
Install Commerce Server Business Management Applications
Install Commerce Server Adapters for BizTalk Server
Upgrade Requirements
Uninstall Commerce Server 2007
Troubleshoot Your Commerce Server Installation
Unattended Installation Command Syntax Reference
The following table lists additional resources.
For information about / SeeQuick Installation Guide for Microsoft Commerce Server 2007 /
Microsoft Commerce Server 2007 Migration topics /
Commerce Server 2007 Deployment topics /
Microsoft Commerce Server 2007 Starter Site Release 2 Installation Guide and Help /
Commerce Server 2007 Component Overview
This document provides instructions about how to install Commerce Server 2007 onto a single computer. This requires meeting hardware and software prerequisites, creating user accounts, installing and configuring Commerce Server 2007, performing post-installation procedures to set up the Commerce Server environment, and then installing the Commerce Server Business Management applications and Commerce Server Adapters for Microsoft BizTalk Server.
Note
Specific restrictions apply to the co-location of certain software components as described in Commerce Server Installation Considerations and Restrictions.
You must perform all tasks in the order indicated.
Note
This Installation Guide is for single-computer installations and does not include information about how to help secure Microsoft Commerce Server 2007 services in a multi-computer configuration. For instructions about how to enhance security and how to deploy Microsoft Commerce Server 2007 on multiple computers, see
Note
Firewall settings on Windows Sever 2003 and Windows Server 2008 must be set to allow traffic to pass through TCP/IP ports without being blocked. The firewall is on by default under Windows Server 2008 so you must run the process to unblock the required ports prior to using Commerce Server in a live environment. The firewall port unblocking process is included as part of the SP2 update to Commerce Server for Windows Server 2008.
Commerce Server 2007 supports installation scenarios that address the needs of developers, IT professionals, business users, and system integrators. The installation scenarios are as follows:
Microsoft Commerce Server 2007. Installs the most common program features required to run a Commerce Server 2007 Web server. This includes the Commerce Server 2007 components and Commerce Server Manager. In addition, you can install one or more of the following optional components: Direct Mailer, Project Creation Wizard, Staging, Health Monitoring, and the Volume Shadow Copy Writer Service. These components provide additional functionality that IT professionals and developers use.
Microsoft Commerce Server Business Management Applications. Installs the Business Management applications that you select: Catalog Manager, Catalog and Inventory Schema Manager, Marketing Manager, and Customer and Orders Manager. Business users and IT professionals use these applications.
Microsoft Commerce Server Adapters for Microsoft BizTalk Server. Installs four Commerce Server adapters: BizTalk Server adapter for catalogs, BizTalk Server adapter for inventory, BizTalk Server adapter for orders, and the BizTalk Server adapter for profiles. System integrators use the Commerce Server adapters to support line-of-business (LOB) application integration and data exchange.
The following table indicates the Commerce Server 2007 components that you typically install to support each server role.
Commerce Server component / System administrator computer / Developer computer / Web server / Business user computer / System integrator computerCommerce Server Core Components / Yes / Yes / Yes / No / No
Direct Mailer / Yes / No / No / No / No
Project Creation Wizard / No / Yes / No / No / No
Staging / Yes / Yes / Yes / No / No
Health Monitoring Service / Yes / No / Yes / No / No
Volume Shadow Copy Writer Service / Yes / No / No / No / No
Business Management applications / Yes / Yes / No / Yes / Yes
Commerce Server Adapters for BizTalk Server / No / No / No / No / Yes
Pre-installation Requirements and Procedures
Before you install and configure Commerce Server 2007, follow these steps:
1.Review Hardware Requirements.
2.Review Software Requirements.
3.Review Commerce Server Installation Considerations and Restrictions.
4.Install Prerequisite Software.
5.Create User Accounts.
6.Set IIS to Use ASP.NET
7.Verify ThatSQL Server is Running
Hardware Requirements
The following table shows the minimum hardware requirements for installing Commerce Server 2007 onto a single computer that is running Windows Server 2003 with SP2, Windows Server 2003 R2 with SP2, Windows Server 2008, or Windows XP.
Processor / Single 1.0 gigahertz (GHz) or faster (Dual 2.0 GHz recommended)RAM / 1024 MB
Storage / 9.0 gigabytes (GB)
External drives / CD drive or DVD drive
Network adapters / 1 10 MBps or larger bandwidth
Monitor / Compatible VGA or higher-resolution monitor
Note
For more information about hardware requirements for specific deployment scenarios, see
The following table shows the minimum hardware requirements for installing Commerce Server 2007 onto an installation of a single computer that is running Windows Vista Business, Ultimate, or Enterprise Edition.
Processor / Single 1.0 gigahertz (GHz) or faster (Dual 2.0 GHz recommended)System Memory / 1 GB
Storage / 40 GB hard disk
External drives / CD drive or DVD drive
Network adapters / 1 10 MBps or larger bandwidth
Monitor / Compatible VGA or higher-resolution monitor
Software Requirements
The following sections list the prerequisite software you must install on the server that will run Commerce Server 2007:
Microsoft Operating System and Web Server Software Requirements
Additional Prerequisite Software Requirements
Microsoft Operating System and Web Server Software Requirements
Commerce Server requires access to an installed SQL Server system, which you should install and configure prior to installing Commerce Server. Commerce Server supports SQL Server 2000 and SQL Server 2005.
Note
When using Commerce Server Data Warehouse capabilities with SQL Server 2005 Developer Edition, you must explicitly enable the TCP/IP Protocol to allow a save of DTS packages using the Data Warehouse Import Wizard.
The following table lists the supported Microsoft operating systems and Web server software that you must install on the server that will run Commerce Server 2007. Note the following:
Microsoft Windows Server2003 Web Edition and Windows Server 2008 Web Edition support all Commerce Server features except for the Data Warehouse and Analysis, and requires that you install Microsoft SQL Server on a separate server.
Windows XP (32-bit) and (64-bit) supports Commerce Server 2007 Developer Edition. For both versions of Windows XP, there is an upper limit of 10 incoming connections enabled. For more information about the incoming connection limitation, see
Windows XP (32-bit) does not support creating the applications pools that are required to support Commerce Server Web applications. For development, you can use the default application pool. You can address this issue by adding an identity tag to your Web.config file to set a user name and password for the ASP.NET worker process. You can then use the Aspnet_setreg.exe tool to encrypt the user name and password in the registry. This will enable your Web service and commerce site to authenticate correctly. For more information about how to set the identity tag, see For more information about how to use the Aspnet_setreg.exe tool, see
Windows XP (64-bit) does support creating application pools.
Windows Server 2008 Itanium-based and Windows Server 2008 HPC Editions do not support Commerce Server 2007.
Windows Server 2003 Datacenter and Itanium Editions do not support Commerce Server 2007.
Windows Vista Business, Ultimate, or Enterprise Editions support Commerce Server 2007 Developer Edition or for the business user computer.
Windows Vista Home Edition and Home Basic Edition do not support Commerce Server 2007.
Windows Vista does not support the Data Warehouse and analytics, or Commerce Server Staging.
Always apply the latest critical Windows updates for the operating system you select.
For information about software requirements that address all the computer scenarios for a Commerce Server enterprise deployment, see
Software / Developer or system administrator computer / Commerce Server 2007 Web server / Business user computer / System integrator computerMicrosoft Windows operating systems (with critical updates):
Microsoft Windows Server 2008 Standard / Yes / Yes / Yes / Yes
Microsoft Windows Server 2008 Standard x64 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2008 Enterprise / Yes / Yes / Yes / Yes
Microsoft Windows Server 2008 Enterprise x64 / Yes / Yes / Yes / Yes
Microsoft Windows Web Server 2008 / Yes
(does not support Data Warehouse and Analysis Reporting and requires SQL Server to be installed on a separate server) / Yes / Yes / Yes
Microsoft Windows Server 2008 Datacenter / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Standard Edition with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Standard x64 Edition with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Enterprise Edition with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Enterprise x64 Edition with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Web Edition with SP2 / Yes
(does not support Data Warehouse and Analysis Reporting and requires SQL Server to be installed on a separate server) / Yes / Yes / Yes
Microsoft Windows Server 2003 Standard Edition R2 with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Standard x64 Edition R2 with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Enterprise Edition R2 with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows Server 2003 Enterprise x64 Edition R2 with SP2 / Yes / Yes / Yes / Yes
Microsoft Windows XP Professional Edition with XP COM+ Hotfix Rollup Package 13 with SP2 / Yes (Commerce Server 2007 Developer Edition only. Review the previous notes about limitations with Windows XP and Commerce Server deployment requirements.) / No / Yes / No
Microsoft Windows XP Professional x64 Edition with XP COM+ Hotifx Rollup Package 13 with SP2 / Yes (Commerce Server 2007 Developer Edition only. Review the previous notes about limitations with Windows XP and Commerce Server deployment requirements.) / No / Yes / No
Windows Vista Business / Yes (Commerce Server 2007 Developer Edition only) / No / Yes / No
Windows Vista Enterprise / Yes (Commerce Server 2007 Developer Edition only) / No / Yes / No
Windows Vista Ultimate / Yes (Commerce Server 2007 Developer Edition only) / No / Yes / No
Other:
Internet Information Services (IIS) / Yes / Yes / Yes / Yes
Internet Information Services 7.0 with IIS 6.0 Compatibility enabled / Yes / Yes / Yes / Yes
Important
Always apply the latest critical Windows updates for the operating system you select.
Additional Prerequisite Software Requirements
The following table lists additional prerequisite software you must install on the server(s) that will run Commerce Server 2007.
Software / Developer or system administrator computer / Commerce Server 2007 Web servers / Business user computer / System integrator computerMicrosoft SQL Server2000 Enterprise Edition with SP4
OR
Microsoft SQL Server2005 with SP2
OR
Microsoft SQL Server 2005 Express Advanced Services Edition with SP2 / Yes / No / No / Yes
Microsoft SQL Server2000 Analysis Services with SP4
OR
Microsoft SQL Server 2005 Analysis Services with SP2 / Yes
(for Data Warehouse and Analysis Reporting) / No / No / Yes
SQL Server 2000 Distributed Transformation Services (DTS) Designer Components / Yes
(required for Data Warehouse DTS tasks) / No / No / No
Microsoft Visual Studio 2008:
Visual Web Developer 2008 Express Edition
Visual Studio 2008 Standard
Visual Studio 2008 Professional
Visual Studio 2008 Team Edition for Software Architects or Team Edition for Software Developers
Visual Studio Team Foundation Server 2008 / Yes (for developing Web applications) / No / No / Yes (for developing applications that use BizTalk Server)
Microsoft Visual Studio 2005:
Visual Web Developer 2005 Express Edition with SP1
Visual Studio 2005 Standard with SP1
Visual Studio 2005 Professional with SP1
Visual Studio 2005 Team Edition for Software Architects or Team Edition for Software Developers with SP1
Visual Studio Team Foundation Server 2005 with SP1
Important
Visual Studio 2005 Premier Partner Edition installs as part of SQL Server2005. However, it does not meet the Commerce Server 2007 software prerequisites. Therefore, you cannot use some features of Commerce Server 2007 such as the Project Creation Wizard unless you install one of the stand-alone versions of Visual Studio 2005. / Yes
(for developing Web applications) / No / No / Yes
(for developing applications that use BizTalk Server)
Microsoft .NET Framework2.0 with KB913393 update
OR
Microsoft .NET Framework 3.0 or 3.5 / Yes / Yes / Yes / Yes
Microsoft ADO.NET Hotfix / Yes / Yes / Yes / No
Register ASP.NET 2.0 as the default framework / Yes / Yes / Yes / No
Microsoft BizTalk Server 2006 with any applicable service packs and hotfixes / Optional
(required to use Commerce Server Adapters for Microsoft BizTalk Server) / No / No / Yes
Microsoft Operations Manager (MOM)2005 with SP1 / Optional / No / No / No
Microsoft Commerce Server 2007 Management Object Model (MOM) Pack / Optional / No / No / No
For information about how to install the additional prerequisite software, see Install Prerequisite Software.