Commerce Server Database Connection Strings

  • Article

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

Ee824480.note(en-US,CS.20).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 by using Commerce Server Manager.
  • Databases used by resources. When you unpack a site by 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 the Data Warehouse has its own snap-in extension.
  • 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 Migration ProfileBuilder tool, 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 Lightweight Directory Access Protocol (LDAP), use the LDAP connection string dialog box, to enter the connection strings for the databases and LDAP sources to which you are mapping data source partitions.
    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.

See Also

Changing Database Connection Strings

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 Profile Store

Copyright © 2005 Microsoft Corporation.
All rights reserved.