How to Configure Reporting Services

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