bobbytables - Wednesday, March 29, 2017 7:57 AM
No.
If you want to use AGs, then no shared storage, SQL is not installed as clustered. The cluster service is there to support SQL's failover behaviour.
Typically, on busy 'enterprise' server, you'll find SSAS and SQL engine on different servers, because of the resource requirements. especially if the failover requirements are different. SSRS also separate, more because of security and patching there (it's a web server)
Only time I've seen all of them on one server is when someone went 'next, next, select all, next, next...' through the install dialog, not because they were intentionally designed to be all on one server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability