Changing Database Connection Strings

  • Article

Commerce Server connection strings are stored in the Administration database. It is recommended that you configure all database connection strings with Window Authentication. For information about configuring your site to use Windows Authentication, see Using Windows Authentication.

Commerce Server uses connection strings for the following databases:

  • Administration database.****During Setup, you configure the connection string for the Administration database. You can the connection string a later date using Commerce Server Manager. For instructions, see Changing the Administration Database Connection String.
  • Direct Mailer database. During Setup, you configure the connection string for the Direct Mailer database. You can change it at a later date using Commerce Server Manager. For instructions, see Configuring Direct Mailer.
  • 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
    Business Desk Permissions SDT Database
    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 the Data Warehouse has its own snap-in extension.

    The connection string for the Data Warehouse resource to the OLAP database only supports Windows Authentication.
  • Other databases. You also specify connection strings in the following cases:
    Feature Connection string
    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 the ProfileBuilder, source code, 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 box) to enter the connection strings for the databases and LDAP sources you are mapping data source partitions to.
    Predictor resource Enter the connection string only if you are building models against an external database, not the Data Warehouse.

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

This section contains:

See Also

Using Windows Authentication

Configuring Data Warehouse Connection Strings

Configuring the Predictor Connection String to an External Database

OLE DB Connection Strings for the Data Warehouse

OLE DB Connection Strings for the Profiling System

Code to Connect to the Expression Store

Code to Retrieve the Predictor Database Connection String

Code to Connect to the Profiles Store

Copyright © 2005 Microsoft Corporation.
All rights reserved.