Why SSDT BI installation needs SQL Server installation as we are ultimately going to deploy BI packages on server where SQL Server would already be available? I need it for SSRS.
Asked
Active
Viewed 229 times
-1
-
SSIS? SSAS Tabular? SSAS Multidimensional? SSRS? Which are you using? – GregGalloway Apr 22 '17 at 00:21
-
SSRS - I have edited question also. – Vikas Apr 24 '17 at 16:29
1 Answers
1
SSDT BI does not require SQL Server installed. SSRS does. The tool allows you to develop your reports and when it comes to the Deploy point, you will need an SSRS instance which requires SQL Server. SSDT BI may install a local instance of SQL Server Express, but it is not used for SSRS but for SQL Tools.