ARCHIVED: What software prerequisites and configurations do I need for creating data connections from SSRS to SSAS?

Within the data warehouse, Reports Developers use Business Intelligence Development Studio to develop and deploy SQL Server Analysis Services projects, and SQL Server Management Studio to manage the Analysis Services databases and process cubes. To successfully access the SQL Server Analysis Services database environment and create dimensions and cubes, you will need to configure and install all prerequisite software to connect to data sources.

On this page:


Data sources

As you configure your tools and create data connections, you will be asked for server names for the analysis server database. Use the following connection strings:

 ebi x.uits.iu.edu:2385 - for ENT (Enterprise) ebi x.uits.iu.edu:2386 - for ORGUNIT (Departmental)

*Replace x with the appropriate server letter designation (e.g., ebid.uits.iu.edu:2385 for Dev, ebip.uits.iu.edu:2386 for Production).

SQL Server

  1. Download SQL Server 2012 from IUware.
  2. Run setup.exe.
  3. Click Installation, and then click New installation or add features to an existing installation.
  4. After all rules have passed, click OK.
  5. Click Install, and then click Next.
  6. Choose I accept the license terms, and click Next.
  7. Click Next again.
  8. Click Next again after the Setup Support Roles have passed (SQL Server Feature Installation). Disregard the Windows Firewall rule warning.
  9. Click Next again.
  10. From the shared features, select both SQL Server Data Tools and Management Tools - Basic and Complete. Click Next again.
  11. Click Next and accept the default settings for the remaining steps. Select Install when prompted. This will take several minutes to complete.
  12. Click Close.

To make your first connection using Visual Studio 2010 Shell (Data Tools Edition), see ARCHIVED: How do I create a data source connection in SSRS?

This is document bcmk in the Knowledge Base.
Last modified on 2016-08-30 10:50:50.

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