Chapter 2: Configuring SQL Server 2005 Business Intelligence Components

When it comes to configuring the business intelligence (BI) server components in SQL Server 2005, the primary focus is on SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). These technologies require server setup configuration properties and instance-wide settings. SQL Server Integration Services (SSIS) also contains a server component, but the primary purpose of the SSIS service is package management, which is reviewed in Chapter 12, Deploying and Configuring SSIS Packages and Chapter 15, Securing and Executing SSIS Packages.

This chapter considers aspects of SSRS and SSAS configurations and settings. Configuring SSRS includes working with the Reporting Services Configuration Manager tool, the command-line management tool called rsconfig.exe, and the command-line key management tool called rskeymgmt.exe to set up the SSRS database repository, configure the Internet Information Services (IIS) Web site directories, and manage the encryption keys. In addition, to work with SSRS, you might need to enforce secure SSL connections and configure SSRS for Internet deployment.

Configuring SSAS includes setting up server security roles and permissions and server properties to capture queries, set up logging, and configure data storage locations.

Exam objectives in this chapter:

  • Configure SSAS.
    • Configure query logging.
    • Configure error logging.
    • Configure disk allocation.
  • Configure server and database roles and permissions.
  • Configure an SSRS infrastructure.
    • Configure SSRS for Internet deployment.
    • Create and configure SSRS instances by using the Reporting Services Configuration tool (Rsconfig.exe).
  • Install an SSRS infrastructure.
    • Manage private keys for encryption.

     Next >



© Microsoft. All Rights Reserved.