用于 SQL Server 2005、Reporting Services、IIS 的安全/最佳实践设置的服务器数量
我想要设置一个 SQL Server 2005 数据库、一个 Reporting Services 实例和 IIS，以便通过 Web 和 Web 应用程序查看报表。
有多少服务器最适合此设置？我听说过关于将 IIS 与 SQL Server 安装在同一台机器上的安全性的各种说法。
我正准备为此类配置定价一些服务器，并希望确保购买足够的数量。
I want to set up a SQL Server 2005 database, a Reporting Services instance, and IIS to view reports via the web and web applications.
How many servers are optimal for this setup? I hear various things about the security of having IIS on the same box as a SQL Server.
I'm preparing to price out some servers for this type of configuration and want to make sure I buy enough.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我会考虑在 DMZ 中至少有 1 个 IIS 盒子，在防火墙后面有一个 SQL Server 盒子（带有报告服务）。
至于性能，它实际上取决于您期望的负载。 IIS 可以轻松实现负载平衡，但如果您严重依赖会话状态，那么您将需要使用 IP 亲和性来确保当在一个机器上启动会话时，始终可以从该机器访问该会话。
SQL Server 还与 SANS 单元很好地集群，为数据库提供通用存储位置。或者您可以考虑主动-被动的日志传送。我什至看到人们将日志传送用于数据库的可更新版本和用于报告的只读版本。
显然还有很多路要走。但如果你能详细说明你期望的负载，那么我可能会给出更好的建议。否则，请密切关注性能并根据需要调整或添加硬件。
I would consider at a minimum 1 box for IIS in a DMZ and one SQL Server box (with reporting services) behind the firewall.
As for performance it really depends on the load you expect to have. IIS can be load balanced easily, but if you are heavily dependent on Session State then you will need to use IP Affinity to make sure when a session is started on one box that that session is always accessed from that box.
SQL Servers also cluster well with a SANS unit to give a general storage place for the Databases. Or you could consider log shipping for an active-passive. I have even seen people use log shipping for a updatable version of the db and a read-only version for reporting.
Clearly there are many ways to go. But if you could elaborate on the load you expect then I could probably give a better suggestion. Otherwise keep an eye on the performance and tune or add hardware as needed.