Setting Database Connection Strings

  • Article

Commerce Server connection strings, including the login user names and passwords, are stored in the Administration database.

Ee799571.note(en-US,CS.10).gif Note

  • All Commerce Server connection strings use Microsoft SQL Server security. However, the connection string for the Data Warehouse resource to the online analytical processing (OLAP) server database only supports Microsoft Windows NT Authentication.

Commerce Server uses connection strings for the following databases:

  • Administration database and Direct Mailer database. During Setup, you enter the login user names and passwords for the Administration database and Direct Mailer database. You can change these at a later date using Commerce Server Manager.

  • Databases used by resources. When you unpack a site using Commerce Server Site Packager, for some resources you are prompted for a connection string to the appropriate database. The following table lists the connection strings for each resource.

    Resource Connection string
    Product Catalog Catalog Database
    Campaigns Campaigns Database
    Transactions Transactions Database
    Transaction Config Transactions Config Database
    Profiles s_BizDataStoreConnectionString, s_CommerceProviderConnectionString, s_ProfileServiceConnectionString
    Data Warehouse The connection string is not named in the user interface because Data Warehouse has its own snap-in extension.

  • Other databases. You also specify connection strings in the following cases:

    Feature Connection string
    App Default Config resource: Integrating with BizTalk Server Set the connection string to the BizTalk Interchange Manager database, which stores messages sent from Commerce Server.
    List Manager: Importing and exporting lists In the List Manager module in Commerce Server Business Desk, set the connection string for the SQL Server database table you are importing or exporting.
    Migration ProfileBuilder Tool After you modify Migration ProfileBuilder, create a Data Source Name (DSN) for the Commerce Server Profiles data store.
    Profiles resource: Adding data sources Use the data source picker (and for the Lightweight Directory Access Protocol (LDAP) , the LDAP connection string dialog) to enter the connection strings for the databases and LDAP sources you are mapping data source partitions to.
    Predictor resource Enter the connection string for an external database, not for the Data Warehouse.

If you need to change a connection string for a database, use Commerce Server Manager.

To change the connection string for the Administration database

To change the connection string for a global resource

To change the connection string for a site resource

To change the connection string for the Administration database

  1. Right-click Commerce Server Manager, and then click Properties. The Commerce Server Manager Properties dialog box appears.

  2. In the Administration Database tab, click Modify. The Data Link Properties dialog box appears.

  3. After making the necessary changes in the Data Link Properties dialog box, click OK.

    For information about how to complete the Data Link Properties dialog box, click Help in the Data Link Properties dialog box to open the Microsoft Data Link Help file.

Ee799571.note(en-US,CS.10).gif Note

  • After you change a property value in Commerce Server Manager, you must unload the IIS applications in the site from memory on each Web server in order for the change to take effect. For instructions, see Unloading an Application from Memory.

To change the connection string for a global resource

Because the Data Warehouse global resource has its own snap-in extension with a different user interface, this procedure does not apply. For instructions about changing the Data Warehouse connection string, see Configuring the Data Warehouse Resource.

  1. Expand Commerce Server Manager, and then expand Global Resources.

  2. Right-click the global resource to be configured, and then click Properties.

  3. Select the Connection Strings tab to configure the connection strings for the global resource, select a connection string, and then click Modify. The Data Link Properties dialog box appears.

  4. After making the necessary changes in the Data Link Properties dialog box, click OK.

Ee799571.note(en-US,CS.10).gif Note

  • After you change a property value in Commerce Server Manager, you must unload the IIS applications in the site from memory on each Web server in order for the change to take effect. For instructions, see Unloading an Application from Memory.

To change the connection string for a site resource

  1. Expand Commerce Server Manager, expand Commerce Sites, and then expand the site you want to administer.

  2. Expand Site Resources, right-click the site resource to be configured, and then click Properties.

  3. In the Properties dialog box, select the Connection Strings tab, select a connection string, and then click Modify. The Data Link Properties dialog box appears.

  4. After making the necessary changes in the Data Link Properties dialog box, click OK.

Ee799571.note(en-US,CS.10).gif Note

  • After you change a property value in Commerce Server Manager, you must unload the IIS applications in the site from memory on each Web server in order for the change to take effect. For instructions, see Unloading an Application from Memory.

See Also

Connection Strings for the Data Warehouse

Connection Strings for the Profiling System

Code to Connect to the Expression Store

Code to Retrieve the Database Connection String

Code to Connect to the Profile Store


All rights reserved.