Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?



migration rejected from Nov 26 '13 at 20:04

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Kin, bluefeet, Aaron Bertrand Nov 26 '13 at 20:04

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

Sage advice - Hire a Professional. Your question is too broad and might be closed. If you have specific question, then feel free to modify your question to reflect the same. – Kin Nov 26 '13 at 20:01
...or post a new, more specific question, since that will be much easier than the process of editing this one and getting it re-opened. – Aaron Bertrand Nov 26 '13 at 20:25