Tool Search: SSRS Server Configuration
The SSRS Server Configuration tool allows districts to set up a connection to an SSRS server from Infinite Campus that can run custom reports. Standard Infinite Campus hosting models include access to an SSRS server upon request.
SSRS Server Configuration Fields
| Field | Description |
| Server Name | The display name of the SSRS Server. |
| Execution URL | Base URL called when executing reports. See below for how you would get this value. |
| Management URL | Base URL called when managing reports. See below for how you would get this value. |
| Username | The username used to log into the SSRS Server. |
| Password | The password used to log into the SSRS Server. |
| Test Connection | Used to test the connection of the server. If the test is successful, continue to SSRS Report Configuration. If not, reenter your credentials and try again. |
Setting Up SSRS Server Configuration
- Click New.
- Enter Server Name.
- Enter the Execution URL.
- Enter Management URL.
- Enter Username.
- Enter Password.
- Click Test Connection to verify the information entered is correct.
- Click Save. You'll be taken back to the server list, and a green confirmation will appear in the top right-hand corner.
Establishing Execution and Management URLs
To get the execution and management URLs for SSRS server configuration tool, you start with the login URL for your campus site:
https://my-district.infinitecampus.org/campus/mydistrict.jsp
Take base URL:
https://my-district.infinitecampus.org
For the Execution URL, add:
:82/ReportServer/ReportExecution2005.asmx
For the Management URL, add:
:82/ReportServer/ReportService2010.asmx
Your Execution and Management URL should look like this, respectively:
https://my-district.infinitecampus.org:82/ReportServer/ReportExecution2005.asmx
https://my-district.infinitecampus.org:82/ReportServer/ReportService2010.asmx
The values should be assumed to be case-sensitive.
If you have configured your own server, the value for ‘ReportServer’ may have been changed and can be found in Reporting Services Configuration Manager > Web Service URL > Virtual Directory on the SSRS report server itself.
