The Microsoft’s Business Intelligence Development Studio, shortly called as BIDS does not come with SQL Server 2014 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 Microsoft SQL Server Data Tools. In order to download the application, please click on this link: Microsoft Business Intelligence for Visual Studio 2013 and select the language (by default English is selected), and click the download button.
Once the download is completed, click on the SETUP will open the following windows.
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 to select the first option: New SQL Server stand-alone installation or add features to an existing installation
Next, we have to accept the licence terms and click the Next button
Next, application will look for Global rules and 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 Next button
Once you click on the Next button, installation process will start
Once the installation process is completed, Your SQL Server 2014 installation completed successfully with 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
Thank You for Visiting Our Blog