Install SQL Server Data Tools

Microsoft’s Business Intelligence Development Studio, shortly called BIDS does not come with the latest SQL Server like it did in SQL Server previous versions. Furthermore, Microsoft has renamed the BIDS as Microsoft SQL Server Data Tools Business Intelligence.

This article will show you the step by step approach to install Business Intelligence Development Tools or Microsoft SQL Server Data Tools. We can also say, install SSRS, or install SSIS, etc.

To download the application, please click on this link: Microsoft Business Intelligence for Visual Studio and select the language (by default English is selected), and click the download button.

Install SQL Server Data Tools 0

Once the download completed, click on the SETUP will open the following windows.

Install SQL Server Data Tools 0

How to Install SQL Server Data Tools

If you are upgrading from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012, then select the second option.

In this example, and or we don’t have any previous installation. So, we are selecting the first option. I suggest you choose the first option: New SQL Server stand-alone installation or add features to an existing installation

Install SQL Server Data Tools 1

In this page, we have to accept the license terms and click the Next button

Install SQL Server Data Tools 2

Next, the application will look for Global rules. If you find any errors, try to Re-run.

Install SQL Server Data Tools 3

Next, it will automatically check for the product updates (if any)

Install SQL Server Data Tools 11

In the next screen we have two options:

Perform a new installation of SQL Server 2014: If you installed the 64-bit SQL Server 2014 then you must select this option. Because Microsoft released only 32-bit SQL Server Data Tools.

It means, if you select the second option, you are adding 32-bit components to 64-bit SQL Server, which will raise architectural problems error.

Install SQL Server Data Tools 4

In the next screen, select SQL Server Data Tools – Business Intelligence for Visual Studio 2013 and click the Next button

Install SQL Server Data Tools 5

Once you click on the Next button, the installation process will start

Install SQL Server Data Tools 6

Once the installation process completed, Your SQL Server 2014 installation completed successfully with the product updates window will be displayed. Please click on the close button and start working with SQL Server Data Tools.

Install SQL Server Data Tools 7

Let me open the application by double-clicking the application.

Install SQL Server Data Tools 8

Comments are closed.