Microsoft KB Archive/938245

= How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name &quot;Longhorn&quot; =

Article ID: 938245

Article Last Modified on 6/29/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Reporting Services, when used with:
 * Microsoft Windows Code Name “Longhorn”

-





Beta Information
This article discusses a beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this beta product. For information about how to obtain support for a beta release, see the documentation that is included with the beta product files, or check the Web location where you downloaded the release.



SUMMARY
This article discusses how to install and how to configure Microsoft SQL Server 2005 Reporting Services on a computer that is running Windows Server code name &quot;Longhorn.&quot;



MORE INFORMATION
On any edition of Windows Server &quot;Longhorn,&quot; you can install one of the following editions of SQL Server 2005 that includes Reporting Services:
 * SQL Server 2005 Standard Edition, 32-bit
 * SQL Server 2005 Developer Edition, 32-bit
 * SQL Server 2005 Enterprise Edition, 32-bit
 * SQL Server 2005 Standard Edition, 64-bit
 * SQL Server 2005 Developer Edition, 64-bit
 * SQL Server 2005 Enterprise Edition, 64-bit
 * SQL Server 2005 Workgroup Edition
 * SQL Server 2005 Express Edition with Advanced Services Service Pack 2 (SP2)

After you install the release version of SQL Server 2005, you must install SQL Server 2005 Service Pack 2 (SP2) or a later service pack to obtain support from Microsoft.

Note Microsoft SQL Server 2005 Express Edition with Advanced Services SP2 is already at the SQL Server 2005 SP2 level.

Prerequisites
Before you install Reporting Services, you must enable Microsoft ASP.NET and Internet Information Services (IIS). To do this, you must configure a server role.

After you enable the required features, you must start the World Wide Web Publishing service if you want to install the default configuration of Reporting Services. Otherwise, the SQL Server Setup program only installs Reporting Services and does not configure Reporting Services.

For more information about these prerequisites, see &quot;Preinstallation steps&quot; in the &quot;Install SQL Server 2005 Reporting Services SP2&quot; section.

If you are performing an upgrade
If you are performing an upgrade from an earlier version of SQL Server Reporting Services to SQL Server 2005 Reporting Services, you must use the SKUUPGRADE=1 argument if the following conditions are true:
 * You use an instance of SQL Server Express Edition to host the report server database.
 * You are upgrading from the previously installed edition of Reporting Services and from the previously installed instance of SQL Server Express Edition.

For more information about how to use the SKUUPGRADE=1 argument to upgrade Reporting Services and the instance of SQL Server Express Edition, see the &quot;How to: Upgrade a SQL Server Express report server to other SQL Server editions&quot; topic in SQL Server 2005 Books Online.

For more information about the known issues when you upgrade from one edition of SQL Server 2005 to another edition of SQL Server 2005 SP2, see the readme file of SQL Server 2005 SP2. To obtain the readme file, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=eb05d099-8a66-45f6-84ce-4888760d2af8

Preinstallation steps
 Log on to Windows Server &quot;Longhorn.&quot; Configure a server role and enable ASP.NET and IIS. To do this, follow these steps:  Click Start, and then click Server Manager. In Server Manager, right-click Manage Roles, and then click Add roles. The Add Roles Wizard starts. In the Add Roles Wizard, click Select Server Roles. On the Select Server Roles page, click to select the Web Server (IIS) check box, and then click Next.

Note Because of role dependency, the File Server check box is automatically selected when you click to select the Web Server (IIS) check box.</li> On the Role Services page, expand Common HTTP Features, and then click to select the following check boxes: <ul> Static Content</li> Default Document</li> Directory Browsing</li> HTTP Errors</li> HTTP Redirection</li></ul> </li> Expand Application Development, and then click to select the ASP.NET check box.

Note If you are prompted to add required role services, click OK.</li> Expand Security, and then click to select the Windows Authentication check box.</li> Expand Management Tools, expand IIS 6 Management Capability, and then click to select the following check boxes: <ul> IIS Metabase Compatibility</li> IIS 6 WMI Compatibility</li> IIS 6 Scripting Tools</li> IIS 6 Management Console</li></ul> </li> Click Next, and then click Install.</li></ol>

Note If you do not enable all these features, the Reporting Services option does not appear in the Feature Selection dialog box of the SQL Server Setup program.</li> Verify that the World Wide Web Publishing service is started. If the World Wide Web Publishing service is not started, configure the service to start automatically. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> In Control Panel, click System and Maintenance.</li> <li>Click Administrative Tools.</li> <li>Double-click Services.</li> <li>In the User Account Control dialog box, click Continue.</li> <li>Right-click World Wide Web Publishing Service, and then click Properties.</li> <li>In the World Wide Web Publishing Service Properties dialog box, select Automatic in the Startup type list.</li> <li>Click Apply, click Start, and then click OK.</li></ol> </li></ol>

Step 1: Install SQL Server 2005 or SQL Server 2005 Express Edition with Advanced Services SP2
You can install either SQL Server 2005 or SQL Server 2005 Express Edition with Advanced Services SP2. To obtain SQL Server 2005 Express Edition with Advanced Services SP2, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D

Notes <ul> <li>When you install the release version of SQL Server 2005, you receive a warning message. The warning message explains that this program has known compatibility issues. Click Run program to continue the installation.</li> <li>In the Feature Selection dialog box, make sure that Reporting Services is selected.</li> <li>In the Report Server Installation Options dialog box, select one of the following options: <ul> <li>Install the default configuration</li> <li>Install but do not configure the server</li></ul>

Note We recommend that you select the Install the default configuration option. If you select the Install but do not configure the server option, you can manually configure the report server after the installation has finished. However, you may experience problems when you manually configure the report server. For more information about how to resolve these problems, see the &quot;Troubleshoot configuration problems&quot; section.</li></ul>

Step 2: Install SQL Server 2005 SP2
Note SQL Server 2005 Express Edition with Advanced Services SP2 is already at the SQL Server 2005 SP2 level. Therefore, if you previously installed SQL Server 2005 Express Edition with Advanced Services SP2, go to Step 3.

If you previously installed one of the following editions of SQL Server 2005, install SQL Server 2005 SP2:
 * SQL Server 2005 Standard Edition, 32-bit
 * SQL Server 2005 Developer Edition, 32-bit
 * SQL Server 2005 Enterprise Edition, 32-bit
 * SQL Server 2005 Standard Edition, 64-bit
 * SQL Server 2005 Developer Edition, 64-bit
 * SQL Server 2005 Enterprise Edition, 64-bit
 * SQL Server 2005 Workgroup Edition

For more information about how to obtain SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005

Notes
 * You must make sure that the SQL Server service is started before you install SQL Server 2005 SP2. The SQL Server service must be running to perform an authentication check in the Authentication Mode dialog box of the Setup program.
 * To avoid a system restart, you can stop the SQL Server service after you close the Authentication Mode dialog box. To stop the SQL Server service, follow these steps:
 * In Control Panel, click Administrative Tools, and then double-click Services.
 * In Services, right-click the SQL Server service, and then click Stop.
 * If the SQL Server 2005 User Provisioning Tool starts, start the SQL Server service before you grant administrative rights to a user. You can use the SQL Server 2005 User Provisioning Tool to add Windows user accounts to the SYSADMIN fixed server role.

Step 3: Start the SQL Server service and reset IIS
If the SQL Server service is not started, start the service.

Additionally, if you installed SQL Server Express Edition with Advanced Services SP2 in Step 1, you must reset IIS. To do this, follow these steps:
 * 1) Open a Command Prompt window by using the Run as administrator option.
 * 2) At the command prompt, type iisreset, and then press ENTER.

Configure SQL Server 2005 Reporting Services

 * 1) Start the Reporting Services Configuration tool. To do this, click Start, point to All Programs, point to SQL Server 2005, point to Configuration Tools, and then click Reporting Services Configuration.
 * 2) In the User Account Control dialog box, click Continue.
 * 3) In the Report Server Installation Instance Selection dialog box, type the name of the computer in the Machine Name box.
 * 4) Select the instance of SQL Server 2005 Reporting Services in the Instance Name list, and then click Connect.
 * 5) Click Web Service Identity.
 * 6) In the Web Service Identity dialog box, select ReportServer or Classic .NET AppPool in the Report Server list.
 * 7) Select ReportServer or Classic .NET AppPool in the Report Manager list.

Notes <ul> <li>Reporting Services runs as an earlier application on IIS 7.0. You should avoid running the report server in the default application pool on IIS 7.0. Reporting Services requires that you use an application pool that has the Managed Pipeline Mode option set to Classic. You will receive an &quot;HTTP 500&quot; error message if you run the report server in the default application pool.</li> <li>In Windows Server code name &quot;Longhorn&quot; Beta 3, you cannot configure the application pool of Report Manager to run under a domain user account if you use the customized application pool settings.</li> <li>If you select the Install but do not configure the server option when you install Reporting Services, you must configure the options in the following dialog boxes: <ul> <li>Report Server Virtual Directory</li> <li>Report Manager Virtual Directory</li> <li>Database Setup</li></ul>

For more information about how to configure the options in these dialog boxes, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms159624.aspx

</li></ul>

Configure Report Manager and the report server for local administration
<ol> <li>Click Start, point to All Programs, right-click Internet Explorer, and then click Run as administrator.</li> <li>In the User Account Control dialog box, click Continue.</li> <li>Open Report Manager. By default, the URL of Report Manager is the following:

http:// /reports

If you use SQL Server 2005 Express Edition with Advanced Services SP2, the URL of Report Manager is the following:

http:// /reports$sqlexpress

If you use a named instance of Reporting Services, the URL of Report Manager is the following:

http:// /reports$

</li> <li>Add the URL of Report Manager to the &quot;Local intranet&quot; security zone. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>In Control Panel, double-click Internet Options.</li> <li>In the Internet Properties dialog box, click the Security tab.</li> <li>On the Security tab, click Local intranet, and then click Sites.</li> <li>Under Add this website to the zone, type the URL of Report Manager. If you do not use HTTPS for the default site, click to clear the Require server verification (https:) for all sites in this zone check box.</li> <li>Click Add.</li> <li>Under Add this website to the zone, type http://localhost, and then click Add.

Note After you perform step f, you can open a browser window to http://localhost or to the network computer name. Then you can locally manage the report server and Report Manager.</li></ol> </li> <li>Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to All Programs, right-click Internet Explorer, and then click Run as administrator.</li> <li>In the User Account Control dialog box, click Continue.</li> <li>Open Report Manager by using the URL of Report Manager.</li> <li>On the Home page, click Properties.</li> <li>Click New Role Assignment.</li> <li>Type a Windows user account name by using the following format:

\

</li> <li>Click to select the Content Manager check box, and then click OK.</li> <li>On the Home page, click Site Settings.</li> <li>Click Configure site-wide security.</li> <li>Click New Role Assignment.</li> <li>Type a Windows user account by using the following format:

\

</li> <li>Click the System Administrator check box, and then click OK.</li></ol> </li> <li>Close Report Manager.</li> <li>Use Internet Explorer without the Run as administrator option to reopen Report Manager.</li></ol>

You should have full permissions to all features of Report Manager. These features include the features that you can access by clicking Site Settings on the Home page.

Problem 1
Consider the following scenario. You install SQL Server 2005 Express Edition with Advanced Services SP2 on a computer that is running Windows Server &quot;Longhorn&quot; Beta 3. In the Report Server Installation Options dialog box, you select the Install but do not configure the server option. After the installation, you open the Reporting Services Configuration tool. In this scenario, many red icons appear next to the items in Reporting Services Configuration Manager. Additionally, a green icon appears next to Report Server Virtual Directory.

Workaround for Problem 1
To work around this problem, follow these steps: <ol> <li>In Reporting Services Configuration Manager, click Report Server Virtual Directory.

Note Although a green icon appears next to Report Server Virtual Directory, the virtual directory for the report server is not created.</li> <li>Click Create.</li> <li>In the Create a New Virtual Directory dialog box, select a Web site in the Website list, and then click OK.</li> <li>Click Apply.

Note You may have to click Apply several times before Reporting Services Configuration Manager creates the virtual directory for the report server.</li> <li>In the Report Manager Virtual Directory dialog box, create a virtual directory for Report Manager.</li> <li>In the Web Service Identity dialog box, select ReportServer or Classic .NET AppPool in the Report Server box.</li> <li>Select ReportServer or Classic .NET AppPool in the Report Manager box.</li> <li>In the Database Setup dialog box, create a report server database.</li> <li>Configure other options depending on your requirements. For more information about how to configure Reporting Services, visit the following MSDN Web site:

http://msdn2.microsoft.com/en-us/library/ms157412.aspx

</li></ol>

Problem 2
When you run a script to configure the virtual directory for the report server, you receive the following error message:

HTTP Error 403.1 Forbidden

You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.

Cause of Problem 2
This problem occurs because of a new permission requirement in IIS 7.0. This permission requirement is for ISAPI extensions that use a wildcard (*) script mapping.

Workaround for Problem 2
To work around this problem, follow these steps:
 * 1) Click Start, click Run, type inetmgr, and then click OK.
 * 2) In Internet Information Services (IIS) Manager, expand Web Sites, expand Default Web Site, and then click the virtual directory for the report server.
 * 3) Under Features View, double-click Handler Mappings.
 * 4) Under Actions, click Edit Handler Permissions.
 * 5) Click to select the Scripts check box, and then click OK.

Keywords: kbsql2005rs kbexpertiseadvanced kbhowto kbinfo KB938245

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.