Report Services Report Server

The SQL Server Reporting Services and the AIM Workhub server are the central components of reporting configuration. The two central components might be installed on a single domain or on multiple domains. If the AIM Workhub and SSRS are on a single web domain/server, then an SSRS Report web page in the Document View/Summary View of the Report functionality can correctly raise events via JavaScript.

In a different server instance, an SSRS Report web page will face problems communicating with the AIM Dashboard event object. If they are on different web domains, the SSRS Report web page will also fail to communicate with the event object. This is caused by the web browsers, for security and privacy reasons, preventing pages in different web domains from affecting each other; that is, cross-site scripting (XSS) is disallowed. For more information to resolve this problem, see Cross-Site Communication Solutions.

Configuring Reporting Service in SQL Server

You must have administrator privileges to configure the Reporting Service.

To configure the Reporting Service in SQL Server:

1. On the Start menu, select All Programs, and then select Microsoft SQL Server.

2. Under the Configuration Tools, select Reporting Services Configuration Manager.

   The Reporting Services Configuration Connection window opens. By default, the local computer host name is populated into the Server Name box.

3. If the Report Server is installed on another computer, enter that computer's host name in the Server Name box, and then select Find.

   The server name appears in the Report Server Instance drop-down box.

4. Select CONNECT.

   The Report Server Status is displayed.

5. If the Report Service Status is showing as Stopped, select the Start button.

6. In the left navigation pane, select Service Account.

7. If you select Use built-in account, select the drop-down arrow, and then select any of the following:

   • Local System

   • Network Service

   • Local Service

8. If you select Use another account, enter the user name and password of any of the following accounts:

   • Domain user account

   • Local user account

     Note: The Report Server Windows Service will be fully functional, irrespective of the account you select. However, it is recommended that you select the Domain user account or Network Service. This will enable the Report Server Windows Service with network log-on permissions. Hence, you can easily access the network domain controllers, public file shares, and corporate email servers.

9. In the left navigation pane, select Database.

   The default Current Report Server Database details are displayed.

   Note: If you want to change the default report server database, see the following section.

Changing the Default Report Server Database

To change the default report server database:

10. If you are using an SQL server on another machine, and want to change the default report server database, select Change Database.

    The Report Server Database Configuration Wizard window opens.

11. If you select Create a new report server database, select Next.

12. In the Server Name box, enter the hostname of the computer running SQL server.

13. To select the Authentication Type, select the drop-down arrow in the box.

    If you select Current User - Integrated Security in the Authentication Type box, your Windows domain credentials will be automatically populated.

14. Select Next, enter the Database Name, select the Language, select the Report Server Mode, and then select Next.

15. Select the drop-down arrow to select the Authentication Type, and then select Next.

    A Summary view appears displaying the values you entered. If you want to edit the values, select Previous.

16. To continue to create a new database, select Next.

    A progress status page appears displaying the status of each configuration stage.

17. If the status shows Success, select Finish.

    Note: If want to change the report server database credentials, see the following section.

Changing the Report Server Database Credentials

To change the report server database credentials:

18. In the Authentication Type box, select the drop-down arrow, and select Current User - Integrated Security.

19. Select Next.

20. In the Authentication Type box, select the drop-down arrow, and select SQL Server Credentials.

21. In the User name and Password boxes, type the new credentials, and then select Next.

    The Summary pane displays the new credentials.

22. Verify if the credentials are correct. If not, select Previous, and go back to correct it.

23. To apply the changes, select Next.

    The Progress and status are displayed.

24. If the status shows Success, select Finish.

Configuring Web Service URL

To access the reports in Dashboard, you must configure the URL to be entered into your Web browser.

To configure the web service URL:

25. In the left navigation pane of the Report Services Configuration Manager window, select Web Service URL.

    The Web Service URL page appears in the right navigation pane.

26. In the Virtual Directory box, enter a name.

    Note: By default, the name ReportServerVirDirectory is populated in the Virtual Directory box.

27. In the IP Address box, select the drop-down arrow, and then select All Assigned.

    Note: By default, all IP addresses are bound to the reporting service. If the computer has multiple IP addresses, then reporting can be bound to a single IP address.

28. In the TCP Port box, enter a Port.

    Important: Ensure that the port is free for use, open to network traffic, and not blocked by a firewall.

29. Configure an SSL Certificate for security reasons:

    1. Select the drop-down arrow in the SSL Certificate box, and then select an SSL Certificate.

    2. In the SSL Port box, enter a Port.

    Note: Selecting an SSL Certificate is mandatory. You must purchase a valid SSL Certificate.

30. Select Apply.

    The URL appears in the Report Server Web Service URLs section of the right pane.

31. To verify if the URL is working, select the URL.

    The URL opens in a browser window.

Configuring Report Manager URL

To configure the Report Manager URL:

32. In the left navigation pane of the Report Services Configuration Manager window, select Report Manager URL.

    The Web Service URL page appears in the right navigation pane.

33. In the Virtual Directory box, type a name, and then select Apply.

    The new directory is created, and the URL is activated.

34. Select the URL.

    The Report Manager home page opens in your web browser.

35. Close the web browser.

    You are returned to the Reporting Services Configuration Manager.

36. To close the Reporting Services Configuration Manager, select Exit.