E-mail
Setting Up Reporting Services Access
Before adding and using Reports based on Microsoft SQL Server Reporting Services to Job Manager, you must configure Job Manager to communicate with the Reporting Services Report Server (hereafter referred to as the "Report Server"). This connection is established by providing information in Job Manager to connect to the Web Services interface of the Report Server.
Note: The Web Services interface of the Report Server is installed as part of the MS SQL Server Reporting Services. Consult your Microsoft SQL Server Reporting Services documentation for more information.
Rest mouse pointer over image for information on window objects.
Click to see a detailed description of the window.
The address of the Reporting Services web server here. Include the "http://" prefix and the Virtual Directory in the Server URL. eg: http://www.example.com/ReportServer/. | |
The name of a user with an account that has permission to access the Reporting Services web server. | |
Tests the connection to the Reporting Services web server using the address and login credentials specified above. A message will appear indicating whether or not the test was successful. | |
Connecting to the Report Server
1. Open the Reporting Services Access Setup window by clicking Reports Server Setup in the Administration menu. The Reporting Services Access Setup window will open.
2. Type the address of the Report Server Web Interface in the Server URL field. Addresses must start with "http://" and include the virtual directory used by the Report Server Web Interface. eg: "http://192.168.68.88/ReportServer/".
3. Type the user name and password of a user with permission to access the Report Server Web Interface in the User and Password fields.
4. Click Test Connection ( 
) to test the Report Server Web Interface and login credentials entered above. If the test is successful, a Success message will appear (see capture below). If the test is not successful, recheck the Server URL and user credentials listed and try again.
5. Click OK ( 
). The Success message will close and return you to the Reporting Services Access Setup window.
6. Click OK ( 
) once you have finished configuring Job Manager to connect to the Report Server Web Interface. The Reports Server Setup will close and you can proceed to Adding and Configuring Reports for information on how to add Reports to the system.