Granting Access to the Commerce Server Databases

  • Article

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

This section provides instructions for configuring the database roles on the computers that are running SQL Server.

ms942152.alert_caution(en-US,CS.70).gifImportant Note:

The database SQL login accounts that you create must match the same account names that you created for the Web application and Commerce Server service accounts that you created or that Commerce Server created. For the list of services and default names, see What Are the Required Accounts and Groups?

Follow these steps to grant Commerce Server accounts access to the Commerce Server databases. All tasks are to be performed on computers that are running SQL Server.

  1. On the production database server:

    1. Create SQL login accounts for the following:

      <data domain name>\ASPNet

      <Web domain name>\ASPNet

      <data domain name>\RunTimeUser

      <Web domain name>\RunTimeUser

      <data domain name>\CatalogWebSvc

      <data domain name>\MarketingWebSvc

      <data domain name>\OrdersWebSvc

      <data domain name>\ProfilesWebSvc

      <data domain name>\CSDMSvc

      <data domain name>\CSStageSvc

      <data domain name>\CSHealthMonitorSvc

      <data domain name>\DTSImport

    2. For each account that you created in Step 1a, associate the database accounts together with the database roles. For the required mappings, see What Are the Required Database Accounts and Database Role Mappings? For the DTSImport account, assign the database roles provided for the Commerce Server Production Database Server.

  2. On the Staging database server, create SQL login accounts for the following:

    1. Create SQL login accounts for the following:

      <internal domain name>\CatalogWebSvc

      <internal domain name>\MarketingWebSvc

      <internal domain name>\OrdersWebSvc

      <internal domain name>\ProfilesWebSvc

    2. For each account that you created in Step 2a, associate the database accounts together with the database roles. For the required mappings, see What Are the Required Database Accounts and Database Role Mappings?

  3. On the Data Warehouse and Analytics database server: create one SQL login account for the following:

    1. Create one SQL login account for the following:

      <internal domain name>\DTSImport

    2. For the DTSImport account that you created in Step 3a, associate the database accounts together with the database roles that were defined for the Data Warehouse and analysis server. For the required mappings, see What Are the Required Database Accounts and Database Role Mappings?

In This Section