locked
SQL Server 2014 Standard edition RRS feed

  • Question

  • Could anyone let me know that I have SQL SERVER 2014 Standard edition installed, can I install BI tools with no extra cost?
    Thursday, September 24, 2015 11:33 AM

Answers

All replies

  • Could anyone let me know that I have SQL SERVER 2014 Standard edition installed, can I install BI tools with no extra cost?
    • Merged by Olaf HelperMVP Thursday, September 24, 2015 11:43 AM Same question from same OP
    Thursday, September 24, 2015 11:32 AM
  • The Standard Edition includes the BI features SSIS = Integration Services, SSAS = Analysis Services and SSRS = Reporting Services; yes, you can install them

    You can also download the BI Tools "SSDT = Data Tools" for free here: Download Latest SQL Server Data Tools


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Thursday, September 24, 2015 11:44 AM
  • Hi Prakash,

    While installing SQL Server 2014 you will go on Setup Role after the Install Riles option, so on Setup roles , there are three options as:

    1. SQL Server Feature Installation

    Choose this option to select individual features and shared components. Instance features include Database Engine Services, Analysis Services (native mode), and Reporting Services.

    2. SQL Server PowerPivot for SharePoint

    3. All Features With Defaults

    So first option will install BI tools along with SSMS, or you can choose from the given list.

    For more details about these options go thorugh this page:https://technet.microsoft.com/en-us/library/ee210441(v=sql.120).aspx

    Thanks,

    Avanish


    Live life with joy and happiness! Avanish

    • Proposed as answer by Avanish Tomar Wednesday, October 7, 2015 11:08 AM
    Tuesday, October 6, 2015 3:04 PM