Thursday, September 17, 2009

How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer

Prerequisites

You have a computer that is running one of the following editions of Windows Vista:
  • Windows Vista Business
  • Windows Vista Enterprise
  • Windows Vista Ultimate
You install one of the following editions of SQL Server 2005 that includes SQL Server 2005 Reporting Services:
  • SQL Server 2005 Developer Edition
  • SQL Server 2005 Standard Edition
  • SQL Server 2005 Workgroup Edition
  • SQL Server 2005 Evaluation Edition
  • SQL Server 2005 Express Edition with Advanced Services Service Pack 2 (SP2)
Note SQL Server 2005 Enterprise Edition is not supported on Windows Vista.

After you install the original release version of SQL Server 2005, you must apply SQL Server 2005 Service Pack 2 (SP2) or a later service pack to obtain support from Microsoft. Additionally, SQL Server 2005 Express Edition with Advanced Services SP2 is already at the SQL Server 2005 SP2 level.
Before you install SQL Server 2005 Reporting Services, you must enable Microsoft ASP.NET and Microsoft Internet Information Services (IIS). To enable ASP.NET and IIS, follow these steps:
  1. In Control Panel, click Programs, and then double-click Programs and Features.
  2. In the User Account Control dialog box, click Continue.
  3. Click Turn Windows features on or off.
  4. In the Windows Features dialog box, expand Internet Information Services, expand Web Management Tools, expand IIS 6 Management Compatibility, and then click to select the following check boxes:
    • IIS 6 WMI Compatibility
    • IIS Metabase and IIS 6 configuration compatibility
  5. Expand World Wide Web Services, expand Application Development Features, and then click to select the following check boxes:
    • ASP.NET
    • ISAPI Extensions
    • ISAPI Filters
  6. Expand Common HTTP Features, and then click to select the following check boxes:
    • Default Document
    • Directory Browsing
    • HTTP Errors
    • HTTP Redirection
    • Static Content
  7. Expand Security, and then click to select the Windows Authentication check box.
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.

After you enable the required features, you must start the World Wide 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.

Install SQL Server 2005 Reporting Services

To install SQL Server 2005 Reporting Services, follow these steps:
  1. Log on to Windows Vista, and enable ASP.NET and IIS. For more information, see the "Prerequisites" section.
  2. 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:
    1. In Control Panel, click System and Maintenance.
    2. Click Administrative Tools.
    3. Double-click Services.
    4. In the User Account Control dialog box, click Continue.
    5. Right-click World Wide Web Publishing Service, and then click Properties.
    6. In the World Wide Web Publishing Service Properties dialog box, click Automatic in the Startup Type list.
    7. Click Apply, click Start, and then click OK.
  3. Start to install SQL Server 2005 or SQL Server 2005 Express Edition with Advanced Services SP2.

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

    Notes
    • 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:
      http://support.microsoft.com/kb/913089/ How to obtain the latest service pack for SQL Server 2005
    • If you install SQL Server 2005 Express Edition with Advanced Services SP2, skip step 4 because SQL Server 2005 SP2 is already installed.
    • 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.
    • After you leave the Authentication Mode dialog box, you can stop the SQL Server service to avoid a system restart. To stop the SQL Server service, click Administrative Tools in Control Panel, double-click Services, right-click the SQL Server service, and then click Stop.
    • If the SQL Server 2005 User Provisioning Tool for Vista starts, start the SQL Server service before you grant administrative rights to a user. You can use the SQL Server 2005 User Provisioning Tool for Vista to add Windows user accounts to the SYSADMIN fixed server role easily.
  5. Start the SQL Server service if the service is not started. If you install SQL Server Express Edition with Advanced Services SP2, reset IIS.

    To reset IIS, follow these steps:
    1. Open a command prompt by using the Run as administrator option.
    2. Type IISRESET, and then press Enter.
  6. If you selected the Install but do not configure the server option in the Report Server Installation Options dialog box, configure the report server. To do this, follow these steps:
    1. Start the Reporting Services Configuration tool. To start the tool, 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. Click the instance of SQL Server 2005 Reporting Services in the Instance Name list, and then click Connect.
    5. Configure the server for operation.
    Note Reporting Services runs as a legacy application on IIS 7.0. If you configure the application pool for the Report Server virtual directory on a new Reporting Services installation, one of the following methods:
    • Select Classic .NET AppPool for the report server.
    • Create a new application pool. Then, set the Managed Pipeline Mode option to Classic.
    If you installed Reporting Services by using the default configuration, the report server runs in its own application pool under the NetworkService account. If you use the default configuration, the report server is fully operational on Windows Vista. However, you should avoid running the report server in the default application pool on IIS 7.0. The default application pool has the Managed Pipeline Mode option set to Integrated. You will receive an "HTTP 500" error message if you run the report server in the default application pool.
  7. Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:
    1. Start Windows Internet Explorer.
    2. On the Tools menu, click Internet Options.
    3. Click Security.
    4. Click Trusted Sites.
    5. Click Sites.
    6. Under Add this Web site to the zone, type http://ServerName. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.
    7. Click Add.
    8. Repeat step 7f and step 7g to add the http://localhost URL, and then click Close.
    Note This step enables you to start Internet Explorer and open either the localhost or the network computer name of the server for both the Report Server application and the Report Manager application.
  8. Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps:
    1. Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator.
    2. Open Report Manager. By default, the Report Manager URL is http://ServerName/reports.

      If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is http://ServerName/reports$sqlexpress. If you use a named instance of Reporting Services, the Report Manager URL is http://ServerName/reports$InstanceName
    3. In the Home dialog box, click Properties.
    4. Click New Role Assignment.
    5. Type a Windows user account name by using the following format:
      Domain\User
    6. Click to select the Content Manager check box.
    7. Click OK.
    8. In the Home dialog box, click Site Settings.
    9. Click Configure site-wide security.
    10. Click New Role Assignment.
    11. Type a Windows user account by using the following format:
      Domain\User
    12. Click System Administrator.
    13. Click OK.
    14. Close Report Manager.
  9. Use Internet Explorer without the Run as administrator option to reopen Report Manager.

Use SQL Server Business Intelligence Development Studio in Windows Vista

If you use Business Intelligence Development Studio in Windows Vista, you will experience compatibility issues with the vsprvs development environment.

If you want to open an existing project or an existing solution, or if you want to publish items from Report Designer or from Model Designer to a report server in Windows Vista, you must use elevated permissions to open SQL Server Business Intelligence Development Studio. To do this, follow these steps:
  1. Click Start, click All Programs, and then click SQL Server 2005.
  2. Right-click SQL Server Business Intelligence Development Studio.
  3. Click Run as administrator.
  4. Click Continue.
  5. Click Run Program.
You can now deploy reports and other items to the report server. If you do not have sufficient permissions, you receive error messages. For example, you experience the following issues:
  • You receive "Access denied" error messages when you try to open an existing project.
  • You receive logon failure error messages when you configure a data source connection to a shared data source.
  • When you use the Report Server Wizard to create a report, you receive a logon failure error message when the wizard tries to connect to the external data source that provides data to the report.
To create logins for users who administer databases on the server, you must run SQL Server Management Studio by using the Run as administrator option. Otherwise, you cannot create or modify SQL Server logins or SQL Server database permissions.
Posted by Sudhanshu at 11:15 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)