Install SQL Server Reporting Services

  • Article
Cc526689.chm_head_left(en-us,TechNet.10).gif Cc526689.chm_head_middle(en-us,TechNet.10).gif Cc526689.chm_head_right(en-us,TechNet.10).gif

Install SQL Server Reporting Services

Before you install Microsoft Operations Manager (MOM) Reporting, you must install Microsoft SQL Server 2005 Reporting Services. Install MOM Reporting on the same computer as SQL Server Reporting Services or on a separate computer.

For more information, see Books on SQL Server.

Note

You must have a Simple Mail Transfer Protocol (SMTP) server available in your environment in order to enable the automatic report delivery feature of SQL Server Reporting Services. If you want to use this feature, make sure that you have a valid SMTP server address available before you install SQL Server 2005 Reporting Services.

Tasks

  1. Install SQL Server 2005 Reporting Services
  2. Configure the SQL Server 2005 Report Server
  3. Reapply SQL Server 2005 Service Pack 1
  4. Install Hotfixes for SQL Server Reporting Services

Prerequisites

  • KB 913812 to resolve the "Unable to discover computers in AD after upgrading to .NET Framework 2.0". Download: KB91382 hotfix.
  • KB 913801 to resolve the "Deadlocks may occur with MOM 2005 SP1 on SQL 2005". Download: KB913801 hotfix.

Install SQL Server 2005 Reporting Services

Run SQL Server 2005 Setup and Install the SQL Server 2005 Reporting Services Component.

Procedure DWR.3: To install SQL Server 2005 Reporting Services

  1. On MOMSQL01, insert the SQL Server 2005, Standard Edition CD into your CD-ROM drive.
  2. If your server supports Autorun, the CD will launch the installer and display the Microsoft SQL Server 2005 splash screen. Click Install Server components, tools, Books Online, and samples. If your server does not support Autorun, browse to the Servers directory on the CD and then run Setup.exe.
  3. Read and accept the End User License Agreement.
  4. On the Installing Prerequisites page, review the list of software components that will be installed prior to installing SQL Server, and then click Install.
  5. After the required prerequisites have been installed successfully, click Next.
  6. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.
  7. On the System Configuration Check page, review the configuration details for warnings or errors. If there are any errors or warnings in the list, read the message associated with the error, and then rectify the problem. When you no longer have any errors displayed in the list, click Next to continue the installation.
  8. On the Registration Information page, enter information in the Name and Company text boxes. Then click Next.
  9. On the Components to Install page, select Reporting Services, then click Next.
  10. On the Instance Name page, ensure that Default Instance is selected, and then click Next.
  11. On the Service Account page, select Use a domain user account. For Username, enter MOMService. For Password, enter the correct password. For Domain, enter Fabrikam.
  12. In the Start services at the end of setup section, ensure that Reporting Services is selected, and then click Next.
  13. On the Report Server Installation Options page, click Next.
  14. On the Error and Usage Report Settings page, choose a value that meets your needs, and then click Next.
  15. Complete the installation.
  16. Restart the MOMSQL01 server.

Reapply SQL Server 2005 Service Pack 1

After you install Reporting Services, you need to reapply SQL Server 2005 Service Pack 1 to update the new component.

Procedure DWR.4: To install SQL Server 2005 Service Pack 1 on MOMSQL01

  1. On MOMSQL01, insert the service pack media. On the Welcome page, confirm the features being upgraded, and then click Next to begin the upgrade process.

  2. Read and accept the End User License Agreement, and then click Next.

  3. On the Feature Selection page, click Next.

  4. On the Authentication Mode page, ensure that All Instances and Windows Authentication are selected, and then click Next.

  5. On the Remote User Account page, enter credentials for the Domain Administrator.

  6. On the Ready to install page, click Install to continue.

    Note

    • You may receive a message regarding pending file operations requiring a reboot. If you encounter this message, click Yes, and then proceed with the installation process.
    • You may get one or more messages reading Locked File Found. Since you will be rebooting the servers running SQL Server at the end of the installation process, it is safe to click Continue.

  7. If you are prompted to reboot your server, click OK.

  8. On the Installation Complete page, ensure the installation was successful, and then click Finish to end the upgrade process.

  9. Reboot the server to complete the SQL Server 2005 Service Pack 1 installation.

Install Hotfixes for SQL Server Reporting Services

Next, install several hotfixes for SQL Server Reporting Services.

Procedure DWR.5: To install MOM hotfixes for SQL Server Reporting Services on MOM01

  • On MOM01, install the following hotfixes using defaults:
    • KB 913812 to resolve the "Unable to discover computers in AD after upgrading to .NET Framework 2.0": KB91382 hotfix.
    • KB 913801 to resolve the "Deadlocks may occur with MOM 2005 SP1 on SQL 2005": KB913801 hotfix.

Configure the SQL Server 2005 Report Server

Configure the SQL Server 2005 Report Server to make it functional.

Procedure DWR.6: To configure the SQL Server 2005 Report Server

  1. On MOMSQL01, click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then select Reporting Services Configuration.
  2. On the Report Server Installation Instance Selection page, ensure that the Machine Name is MOMSQL01.
  3. Ensure that the Instance Name is MSSQLSERVER, and then click Connect.
  4. On the Configure Report Server page, click Report Server Virtual Directory.
  5. On the Report Server Virtual Directory Settings page, click New.
  6. On the Create a New Virtual Directory page, accept the default value, and then click OK.
  7. On the Configure Report Server page, click Report Manager Virtual Directory.
  8. On the Report Manager Virtual Directory Settings page, click New.
  9. On the Create a New Virtual Directory page, accept the default value, and then click OK.
  10. On the Configure Report Server page, click Web Service Identity.
  11. On the Web Service Identity page, accept the default values for the Report Server and Report Manager application pools, and then click Apply.
  12. On the Configure Report Server page, click Database Setup.
  13. On the Database Connection page, in the Server Name drop-down box, select MOMSQL01.
  14. On the right of the Database Name text box, click New.
  15. In the SQL Server Connection dialog box, accept the default values, and then click OK.
  16. On the Database Connection page, click Apply at the bottom of the page.
  17. On the SQL Server Connection Dialog page, click OK.
  18. At the bottom of the Database Connection page, click Exit.
  19. Restart the MOMSQL01 server.