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.
Once the download completed, click on the SETUP will open the following windows.
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
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)
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.
In the next screen, select SQL Server Data Tools – Business Intelligence for Visual Studio 2013 and click the Next button
Once you click on the Next button, the installation process will start
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.
Let me open the application by double-clicking the application.