How to Configure Reporting Services

  • Article

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This topic provides steps for configuring SQL Server Reporting Services on a Data Warehouse/Analytics server. The steps describe how to configure SQL Server Reporting Services, how to set up the Report Server database, how to add an account to the local administrators group, and how to assign write permissions to the temporary ASP.NET folder.

Note

You must have SQL Server 2005 Reporting Services already installed on the computer. For information about how to install the Reporting Services, see How to Install SQL Server 2005 Reporting Services.

To configure SQL Server Reporting Services on a Data Warehouse/Analytics server

  1. Click Start, point to AllPrograms, point to Microsoft SQL Server 2005, point to Configuration Tools, and then, click Reporting Services Configuration.

  2. In the Report Server Installation Instance Selection dialog box, do the following:

    Use this

    To do this

    Machine Name

    Accept the default name.

    Instance Name

    Accept the default name, or if you installed a different instance name, select that name from the drop-down list.

  3. Click Connect.

  4. In the left pane of the Configure Report Server window, click Report Server Virtual Directory, and then, in the right pane, click New.

  5. In the Create a New Virtual Directory dialog box, do the following:

    Use this

    To do this

    Website

    Accept the default name or select a Web site from the drop-down box.

    Virtual Directory

    Accept the default name, or type a directory name.

  6. Click OK.

  7. In the left pane of the Configure Report Server window, click Report Manager Virtual Directory, and then, in the right pane, click New.

  8. In the Create a New Virtual Directory dialog box, do the following:

    Use this

    To do this

    Website

    Accept the default name or select a Web site from the drop-down box.

    Virtual Directory

    Accept the default name, or type a directory name.

  9. Click OK.

  10. In the left pane of the Configure Report Server window, click Web Service Identity, and then, in the right pane, on the Report Server line, click New.

  11. In the New Application Pool dialog box, do the following:

    Use this

    To do this

    Application Pool Name

    Type ReportingAppPool.

    Windows Account

    Select this option to use the Windows account.

    Account

    Type the account name, for example, <domain name>\reportingsvc.

    Password

    Type the password for this account.

  12. Click OK.

  13. In the Report Manager box, select ReportingAppPool as the Application pool, and then, click Apply.

  14. In the SQL Server Connection Dialog dialog box, select Current User- Integrated Security from the drop down box. Click OK.

To set up the Report Server database

  1. In the left pane of the Configure Report Server window, click Database Setup.

  2. In the right pane, do the following:

    Use this

    To do this

    Server Name

    Select <local machine name> from the drop-down list.

    Database Name

    Click New.

  3. In the SQL Server Connection Dialog dialog box, click OK to accept the default values.

  4. In the right pane of the Configure Report Server window, do the following:

    Use this

    To do this

    Credentials Type

    Select Windows Credentials from the drop-down list.

    Account Name

    Type the account name, for example, type <domain name>\reportingsvc.

    Password

    Type the password for this account.

  5. Click Apply.

  6. In the SQL Server Connection dialog box, click OK.

  7. Click Exit to close the Reporting Services Configuration Manager.

To add an account to the local administrators group

  1. Click Start, point to AllPrograms, point to Administrative Tools, and then click Computer Management.

  2. In the left pane of the Computer Management window, expand Local Users and Groups, and then click Groups.

  3. In the right pane, double-click Administrators.

  4. In the Administrators Properties dialog box, click Add.

  5. In the Select Users, Computers, or Groups dialog box, do the following:

    Use this

    To do this

    Enter the object to select

    Type the object name, for example, type <domain name>\reportingsvc.

  6. Click OK.

  7. In the Administrators Properties dialog box, click OK.

  8. Close the Computer Management window.

To assign write permissions to the temporary ASP.NET folder

  1. Click Start, click Run, and type explorer, and then click OK.

  2. In Windows Explorer, move to the <drive>:\Windows\Microsoft.NET\Framework\v2.0.50727 folder, and expand the folder.

  3. Right-click Temporary ASP.NET Files, and then click Properties.

  4. In the Temporary ASP.NET Files Properties dialog box, on the Security tab, click Add.

  5. In the Select Users, Computers, or Groups dialog box, do the following:

    Use this

    To do this

    Enter the object names to select

    Type the object name, for example, type <domain or computer name>\reportingsvc.

  6. Click OK.

  7. In the Temporary ASP.NET Files Propertiesdialog box, do the following:

    Use this

    To do this

    Group or user names

    Select the reporting service account.

    Permissions for Reporting Service

    Check the Allow column for Write and clear the other options.

  8. Click OK.

  9. In the Security dialog box, click Yes.

  10. Restart IIS.

See Also

Other Resources

Configuring the Data Warehouse and Analysis Server

Installing and Configuring Reporting Services