How can I connect SSAS to departmental databases?

To build SSAS reports on your departmental databases, your databases must allow SSAS 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 ads\ebiasdb. In the User Rights Assignment local policy, this service 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 SSAS access to your database.

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

Database:

  • 10.234.26.9
  • 10.234.26.150
  • 10.234.26.116
  • 10.79.4.27

SQL Analysis Services:

  • 10.234.26.165
  • 10.234.26.166
  • 10.234.26.143
  • 10.79.4.79

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

Security of your credentials

SSAS 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 aiwv in the Knowledge Base.
Last modified on 2017-01-06 13:59:37.

  • 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.