Commerce Server Database Connection Strings
Commerce Server connection strings, including the login user names and passwords, are stored in the Administration database.
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.