Changing Database Connection Strings
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:
- Changing the Connection String for a Global Resource
- Changing the Connection String for a Site Resource
See Also
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.