We are just now looking at implementing Reporting Services, and I would like to pose a few questions.
1. What are the issues (performance, etc)/dangers (security, etc) of installing Web Services on a SQL Server?
2. What, if anything, can be done to minimize these issues?
3. I would like to get a feeling for how most shops are setting up RS. Are you putting it with an existing SQL installation, or are installing separately?
4. Do you have success/horror stories concerning RS?