I have a task and I don't know how solve it :)
So, we have a lot of customers who should use SQL Server for their applications.
Design is standard and simply:
Customer -> Remote Desktop -> AppServer -> SQL Server
So, now we plan create a SQL Server cluster ('active/passive' or 'active/active/passive' btw which is preferred?) and we are don't know which design for this solution will be the best.
For example we have 50 customers who wants to use DBE/Reporting/Analysis. What your offers about SQL design for solve this case?
What I need to do with 'Reporting Services' and 'Analytics Service' for each customer? Should/can I install it to this cluster, or need to deploy it to another server? Which is the best variant for provide access to each customers DB/Reporting/Analytics?