I have Microsoft SQL Server 2012 Entreprise Edition license, What are the tools needed to work on SSIS/SSAS/SSRS?

Since BIDS was replaced with SSDT on the 2012 version, does it mean I will need to get a separate license and install Visual Studio then get the free SSDT add-in?

Sorry for the confusion, I am new to Microsoft BI and can't find relevant information onlines

1 Answer 1


No, you do not have to buy a VS licence to use SSDT or SSDT-BI, you have the licence for the services (IS, AS, RS) if you have a SQL Server licence. SSDT and SSDT-BI are just tools to use those services.

You can freely download SSDT and SSDT-BI from Microsoft:

Edit It is not required to preinstall any kind of VS, the will install the VS Shell if it is not installed.

Note You can install BIDS/SSDT-BI using the SQL Server installer, but it contains the version which was available when the installer built (mostly hardly outdated).

  • but in both links it says SSDT for VS, does it mean I have to install VS first?
    – mcha
    Nov 25, 2014 at 13:01
  • No, it will install the VS Shell (the core of the VS). You do not have to install any kind of VS. (You can install BIDS/SSDT-BI using the SQL Server install too)
    – Pred
    Nov 25, 2014 at 13:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.