Before using MS SQL Server Reports with Virtual Ticket, you must configure Virtual Ticket to communicate with the Web Services interface of the Reporting Services Report Server (hereafter referred to as 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.
Window Objects
Click to see a detailed description of the window.
Server URL
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/.
User
The name of a user with an account that has permission to access the Reporting Services web server.
Password
The password of the user entered above.
Test Connection
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.
Cancel
Closes the window without saving any entered information.
OK
Closes the window and saves any entered information.
Procedures
Defining the Connection to the Report Server Web Interface
Open the Reporting Services Access Setup window by clicking Reports Server Setup in the Administration menu. The Reporting Services Access Setup window will open.
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/.
Type the user name and password of a user with permission to access the Report Server Web Interface in the User and Password fields.
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.
Click OK (). The Success message will close and return you to the Reporting Services Access Setup window.
Click OK () once you have finished configuring Virtual Ticket 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.
E-mail
