Hello,
We have been using Reporting Services for a few months doing some prototyping and it has gone well enough that we are now being tasked with rolling out an implementation to the enterprise. Here is the hardware that I have to work with:
3 Web Server Cluster managed via Application Center
1 Active/Passive Sql Server Cluster (IIS Installed for XMLA) Attached to fiber array.
So here is my dilema. Is it better to install the Reporting Services WebService on the web servers and have them all pointing to the database server or should I install the web servcies on the same box as the Database. In my mind it could work either way and may even keep the web servers cleaner to go with option 2. I see that the directions show how to install RS into the web farm as in my option 1 but before I went either way I thought I would ping the source and see what you all though.
Thanks for any guidance and direction you may be able to give. Thanks.
RichHi Rich,
Thanks for your post.
From your descriptions, I understood that you would like to find out a more
proper machine to install Reporting Services. Have I understood you?
Correct me if I was wrong.
Based on my scope, it's hard to tell which one might be better. I am not
sure the workload of your database server and web server. I am also not
sure the scenario and requirement of your project.
Generally speaking, it is not recommend to install additional application
in the database server as SQL Server may eat up the resource of machine
when workload was high. From the limited information here, I would love to
select installing Reporting Services in the web server.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
No comments:
Post a Comment