Share via


Configuring Data Warehouse Connection Strings

You can configure the Data Warehouse connection strings programmatically or by using Commerce Server Manager.

Using Commerce Server Manager to Configure the Connection Strings

Programmatically Configuring the Connection Strings

Queries to Read Data Warehouse Connection Strings from the Administration Database

Using Commerce Server Manager to Configure the Connection Strings

  1. In Commerce Server Manager, expand Global Resources, right-click Data Warehouse, and then click Properties.

  2. On the SQL Server tab, specify the authentication mode for the connstr_db_dw and connstr_db_Analysis connection strings.

    • If you specify SQL Server Authentication, the user ID and password will be used in connstr_db_dw, but connstr_db_Analysis (the client-side connection string) will continue to use Windows Authentication for security reasons.
    • If you specify Windows NT Authentication, connstr_db_dw will be configured to use Windows Authentication.

    The following sample dialog box shows which connection strings are configured in the dialog box.

    A sample screen showing how connections strings are configured for the SQL Server Data Warehouse database.

  3. On the Analysis Server tab, specify the authentication mode for the ConnStr_OLAP, ConnStr_OLAP_HA, and ConnStr_OLAP_Client connection strings.

    The following sample dialog box shows which connection strings are configured in each section of the dialog box.

A sample screen showing how connection strings are configured for the Analysis Server.

Programmatically Configuring the Connection Strings

When you configure the Data Warehouse connection strings programmatically, you must also update a set of parsed properties:

  • When you update the Data Warehouse SQL Server connection strings, ConnStr_dw, connstr_db_dw, and connstr_db_Analysis, you must also update the following parsed properties:
    Property Description
    Schema_ctlgDbName
    The Data Warehouse database name, for example, BlankSite_dw.
    Schema_ctlgName
    The schema catalog name, for example, DWSchema.
    Schema_ctlgUserID
    The UserID from the Data Warehouse connection string. This string should be empty if you are using Windows Authentication.
    Schema_ctlgPsw
    The password from the Data Warehouse connection string. This string should be empty if you are using Windows Authentication.
    Schema_ctlgSqlServerName
    The Data Warehouse SQL Server name.
  • When you update the Analysis Server OLAP database connection string, ConnStr_OLAP, you must also update the following parsed properties:
    Property Description
    Schema_ctlgNameOLAPDbName
    The Analysis Server OLAP database name.
    Schema_ctlgNameOLAPServerName
    The Analysis Server name.

Queries to Read Data Warehouse Connection Strings from the Administration Database

You can use the following queries to read the Data Warehouse connection strings from the MSCS_Admin database. These queries are useful when you are trying to determine what connection strings are stored in the Administration database:

Select s_Value from ResourceProps where s_PropertyName = 'connstr_db_dw'
Select s_Value from ResourceProps where s_PropertyName = 'ConnStr_DB_Analysis'
Select s_Value from ResourceProps where s_PropertyName = 'ConnStr_OLAP' 
Select s_Value from ResourceProps where s_PropertyName = 'ConnStr_OLAP_Client'  
Select s_Value from ResourceProps where s_PropertyName = 'ConnStr_OLAP_HA' 

See Also

Configuring Data Warehouse Connection Strings

Configuring the Analysis Server Account

Accessing the Analysis Server Over HTTPS

Scripts for Securing Databases Accessed by Reports

Copyright © 2005 Microsoft Corporation.
All rights reserved.