Data Warehouse Connection Strings
The following table lists the Data Warehouse connection strings.
| Connection string | Description |
|---|---|
| connstr_db_dw connstr_db_Analysis |
Server-side and client-side connection strings used to run reports against the Data Warehouse SQL Server database. |
| ConnStr_OLAP ConnStr_OLAP_Client |
Server-side and client-side connection strings used to run reports against the Analysis Server OLAP database. These are the Primary Analysis Server connection strings. |
| ConnStr_OLAP_HA | Used for high-availability deployments in which there is a second Analysis Server. This is the Secondary Analysis Server connection string. |
| ConnStr_DW | Used by the DTS tasks to access the Data Warehouse through the OLE DB Provider for Commerce Server. |
Configure each connection string to use Windows Authentication.
These connection strings are stored in the Administration database.
See Also
Configuring Data Warehouse Connection Strings
OLE DB Connection Strings for the Data Warehouse
Copyright © 2005 Microsoft Corporation.
All rights reserved.