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.

• Data sources
• SQL Server

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?