Granting Access to the Commerce Server Databases

  • Article

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

Dd328205.alert_caution(en-US,CS.90).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 2009 service accounts that you created or that Commerce Server 2009 created. For the list of services and default names, see What Are the Required Accounts and Groups?  

Follow these steps to grant Commerce Server 2009 accounts access to the Commerce Server 2009 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 2009 production database server.

  2. On the Staging database server, do 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, do 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