How can I connect SSRS to departmental databases?

To build SSRS reports on your departmental databases, your databases must allow SSRS access. See below for the ports and proxy accounts that need access to these sources.

On this page:


Granting access

Provide read access to your database for the ads\sqlrsdev, ads\sqlrstst, and ads\sqlrsprd report services. In the User Rights Assignment local policy, these services will need Access this computer from the network user rights. If your database server firewall doesn't permit global "inbound" access, you'll need to add firewall exceptions to give SSRS access to your database.

Add inbound access to the following IP addresses for ports 1433 UDP/TCP, 1434 TCP, and 2382-2388 TCP:

  • Prod: 129.79.4.82
  • Test: 134.68.27.103 and 10.234.27.79
  • Dev: 134.68.27.92 and 10.234.27.78

Applying these ads\account read additions to the inbound firewall rule set will permit all required network connectivity for SSRS.

Security of your credentials

SSRS stores credentials in a locally encrypted database, which mitigates the risk of compromise or access to stored credentials. For more, see Specify Credential and Connection Information for Report Data Sources.

This is document aino in the Knowledge Base.
Last modified on 2016-05-31 00:00:00.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.