Data Warehouse Properties, SQL Server Tab
Use the Data Warehouse Properties dialog box, SQL Server tab, to configure the Data Warehouse global resource connection to the SQL Server Data Warehouse database. Use this tab to configure two connection strings:
ConnStr_db_analysis. The PivotTable in dynamic reports uses this client-side connection string. Client systems can access this connection string by viewing the source when a dynamic report renders. By default, this connection string uses Windows Integrated Security, even if you specify SQL Security in this dialog box, or when you unpack the Data Warehouse resource.
Because this connection string uses Windows Integrated Security, Windows users who do not have SQL Server permissions will not be able to run the dynamic SQL reports.
ConnStr_db_dw. This Commerce Server 2009 provides this server-side connection string for high availability business analytics configurations. You first set this connection string when you unpack the Data Warehouse resource; it has Administrative rights.
For this connection string, you can select whether to use Windows Integrated Security or SQL Security.
Use this |
To do this |
|---|---|
SQL Server Authentication |
For the Connstr_db_dw connection string, select this option to use SQL security. Commerce Server 2009 does not use SQL Server Authentication for the Connstr_db_analysis connection string. |
Windows NT Authentication |
For the Connstr_db_dw connection string, select this option to use Windows NT Authentication. By default, the Connstr_db_analysis connection string always uses Windows Integrated Authentication. |
User ID |
Type the user ID for SQL Server Authentication. |
Password |
Type the password for SQL Server Authentication. |
Server |
Type the name of the computer that is running SQL Server that contains the Data Warehouse database. |
Database |
Type the name of the SQL Server Data Warehouse database. |