Microsoft’s Business Intelligence Development Studio, shortly called BIDS, does not come with the latest SQL Server like it did in 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 installing Business Intelligence Development Tools or Microsoft Data Tools. We can also say, install SSRS, install SSIS, etc.
To download the application, please click on this link: Microsoft Business Intelligence for Visual Studio, select the language (by default, English is selected), and click the download button.
Once the download completes, click on the SETUP will open the following windows.
How to Install SQL Server Data Tools
If you are upgrading from SQL Server 2005, 2008, 2008 R2, or 2012, then select the second option.
In this example, we don’t have any previous installation. So, we are selecting the first option. I suggest you choose the first option: New stand-alone installation or add features to an existing installation.
In this page, we have to accept the license terms and click the Next button
Next, the application will look for Global rules. If you find any errors, try to Re-run.
Next, it will automatically check for the product updates (if any)
On the next screen, we have two options:
Perform a new installation: If you installed the 64-bit, then you must select this option. Because Microsoft released only 32-bit.
It means that if you select the second option, you are adding 32-bit components to 64-bit SQL Server, which will raise architectural problems error.
In the next screen, select SQL Server Data Tools – Business Intelligence for Visual Studio 2013 and click the Next button to install.
Once you click on the Next button, the installation process will start
Once the installation process completes, Your 2014 installation completed successfully with the product updates window will be displayed. Please click on the close button and start working with the installed SQL Server Data Tools.