Securing the Data Warehouse

This section describes the objects and data that you need to secure for the Data Warehouse, and provides detailed instructions explaining how to secure these objects and data.

It is strongly recommended that you use Windows Authentication for access to your databases. When you configure your database connection strings for Windows Authentication, you must assign Commerce Server Business Desk users and system administrators the appropriate access to your Data Warehouse databases.

Commerce Server includes seven scripts (ReportViewer.sql, ReportAdvanced.sql, and five scripts for the DTS tasks) that create SQL Server database roles and assign the appropriate database permissions to each role. After you run these scripts, you can assign the SQL Server logins for Business Desk users and system administrators to the appropriate roles.

This section contains:

• Overview of Data Warehouse Security
• Data Warehouse Components Requiring Security
• Overview of a Secure Data Warehouse Deployment
• Scripts for Securing Databases Accessed by DTS Tasks
• Permissions Required to Run DTS Tasks
• Scripts for Securing Databases Accessed by Reports
• Permissions Required to Export Static Reports and Segments to List Manager
• Configuring the Analysis Server Account
• Accessing the Analysis Server Over HTTPS
• Configuring Data Warehouse Connection Strings
• Changing the Data Warehouse Password
• Changing the Report Manager Account

Copyright © 2005 Microsoft Corporation.
All rights reserved.