September 11, 2013 at 9:01 am
Why would you want to add SSAS or SSRS as a feature of a database engine instance as opposed to creating a new instance on the same box. What's the use cases?
September 11, 2013 at 9:08 am
SSAS /SSRS and SSIS are merely free tools that Microsoft kindly gives us when we purchase their SQL Server software. You install the SQL Server engine - then you can install other features such as SSRS and SSAS which connect to the databases which the SQL Server engine is responsible for.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
September 12, 2013 at 7:00 am
_nzrdb6 (9/11/2013)
Why would you want to add SSAS or SSRS as a feature of a database engine instance as opposed to creating a new instance on the same box. What's the use cases?
As Abu alludes to, SSRS and SSAS aren't features of the database engine but are separate applications that are included in a SQL Server license. Whether you install them as part of the default installation or as separate instances you still have the same constraints, the CPU power, IO, and memory usage that all require. In reality including them in the license is a great marketing tool for MS because in any kind of large or busy installation you really need to have the 3 products on 3 servers to get the best performance out of each, and that requires 3 SQL Server licenses, not 1.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply