Configuration of Microsoft SQL Server Reporting Services for use with IT Analytics
search cancel

Configuration of Microsoft SQL Server Reporting Services for use with IT Analytics

book

Article ID: 181564

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

 Question
 

What is the method of configuring Microsoft SQL Server Reporting Services for use with IT Analytics?

Resolution

 

Answer
 

Configuration of SQL Server Reporting Services

The below instructions list the steps needed to successfully configure the Microsoft SQL Server 2005 Reporting Services and Analysis Services. For instructions installing or updating SQL Reporting Services to function on a server running Notification Server 6.0 SP3 and R7, refer to the following article:

IT Analytics Solution stops working and won't properly configure when NS 6.0.6074 SP3 R7 or higher is installed
https://knowledge.broadcom.com/external/article?legacyId=TECH39077

Plese Note: If you are unable to get any of the below steps to work, please contact your DBA or Microsoft. Symantec Technical Support is unable to assist in configuring or troublehshooting Microsoft software.

  1. Install SQL server 2005 Reporting and Analysis Services (SSRS & SSAS). Install SSRS and SSAS, but do not configure the services.
  2. Configure the SQL Server Reporting Services using the “Reporting Services Configuration Wizard”(RS wizard) as follows:
    1. On the Reporting Server Virtual Directory tab create a new Reporting Server Virtual Directory with the following [Name] and [Website].
      1. Name: ReportServer
      2. Website: Default Web Site
    2. Click Apply and wait for the RS wizard to complete the creation of the reporting server virtual directory.

      Note: No changes are necessary for the SSL settings unless the customer environment has SSL configured.
    3. Verify that all Reporting Server Virtual Directory tasks complete successfully.
    4. On the Report Manager Virtual Directory, create a new Report Manager Virtual Directory with the following [Name] and [Website].
      1. Name: Reports
      2. Website: Default Web Site
    5. Click Apply and wait for the RS wizard to complete the creation of the report manager virtual directory.
    6. Verify that all Report Manager Virtual Directory tasks complete successfully.
    7. On the Windows Service identity tab, specify the Windows Service Identity for the report server use the following settings:

      Built-In Account:Local System
    8. Click Apply and wait for the RS wizard to complete the report server account configuration.
    9. Verify that all Windows Service Identity tasks complete successfully.
    10. On the Web Service Identity, configure the RS Web Service Identity by creating a new Application Pool for both the Report Server and Report Manager. The new identity was configured as follows:
      1. Application Pool Name: ReportServer
      2. Click the Built-In Account radio button
      3. Click the Network Service”account from the drop-down menu.
      4. Click OK.
    11. In the Report Manager drop-down menu, select the new pool ReportServer from the drop-down menu.
    12. Click Apply and wait for the RS wizard to complete the report server Web service identity configuration.
    13. Verify that all Windows Service Identity tasks complete successfully.
    14. On the Database Setup tab configure the database connection and create a Reporting Server database as follows:
      1. Connect to the Database Engine that will be used for Reporting Services. Note that this is not the Altiris database, and is solely for the operational requirements of Reporting Services. Typically this will be a SQL Server 2000/2005 Database Engine that resides on the same SQL Server instance as Reporting Services.
      2. Click the New button and configure the Reporting Server Database as follows:
        1. Server Name: LOCAL <or Designated SQL Server 2000/2005 Database Engine>

          (Should be completed if you successfully connected to the existing database.)
        2. Credentials Type: Current User – Integrated Security
        3. Username: NULL
        4. Password: NULL
        5. Database Name: ReportServer
        6. Language: English
      3. Click OK then click the Apply button to create the new database and complete the database connection configuration.
      4. Verify that all Database creation tasks complete successfully.
    15. Proceed to the Initialization tab and verify that the new database is initialized. If not, select the database and click the Initialize button.
    16. Click Apply and verify that all Initialization tasks complete successfully.
    17. Install IT Analytics using the Upgrade/Install Additional Solutions item on the Notification Server Configuration tab.
    18. Configure IT analytics using the procedures in the IT Analytics Help PDF in the documentation section of the Altiris Web site.