Answered by:
SQL Server 2014 Standard edition

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
-
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]- Proposed as answer by Shanky_621MVP Thursday, September 24, 2015 11:54 AM
- Edited by Olaf HelperMVP Thursday, September 24, 2015 11:57 AM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Wednesday, October 7, 2015 9:31 AM
Thursday, September 24, 2015 11:44 AM
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]- Proposed as answer by Shanky_621MVP Thursday, September 24, 2015 11:54 AM
- Edited by Olaf HelperMVP Thursday, September 24, 2015 11:57 AM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Wednesday, October 7, 2015 9:31 AM
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,
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