Share via


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.