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:


Grant 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 2018-07-16 16:43:14.

Contact us

For help or to comment, email the UITS Support Center.