SSRS 和 SQL Server 数据库在不同的服务器上
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14211978/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SSRS and SQL Server database on different server
提问by user1193937
Is it possible to install SSRS and SQL Server database on separate servers, or should these two be installed on the same server?
是否可以将 SSRS 和 SQL Server 数据库安装在不同的服务器上，还是应该将这两个安装在同一台服务器上？
Thanks
谢谢
回答by Stefan Steiger
In order to have Reporting Services on your application server, you would have to use a SQL-Server license. You can install just the Reporting Services section of SQLServer, but it is still technically part of the SQL Server application and requires a license for use on that processor(s).
为了在您的应用程序服务器上安装 Reporting Services，您必须使用 SQL-Server 许可证。您可以只安装 SQLServer 的 Reporting Services 部分，但它在技术上仍然是 SQL Server 应用程序的一部分，并且需要在该处理器上使用的许可证。
So yes, you can install it on another server.
Yes, you can install only the advanced services, but that still counts as full server., so it requires a full license.
所以是的，您可以将其安装在另一台服务器上。
是的，您只能安装高级服务，但这仍然算作完整服务器。因此它需要完整许可证。
Yes, you can install an Express Edition (with advanced services) on another server for free.
But... the express edition SSRS can't access a non-localhost database (technical limitations of express & web edition).
You can try to circumvent that with linked-servers, but you need to duplicate every used stored procedure, view, table etc., so it's an impractical mess.
是的，您可以在另一台服务器上免费安装 Express Edition（具有高级服务）。
但是...速成版 SSRS 无法访问非本地主机数据库（速成版和网络版的技术限制）。
您可以尝试使用链接服务器来规避这种情况，但是您需要复制每个使用过的存储过程、视图、表等，因此这是一个不切实际的混乱。
The answer to your question is thus: Technically, yes - but actually NO, not without another license.
That extra-installation is gonna cost USD 1'000+ per month.
因此，您的问题的答案是：从技术上讲，是的 - 但实际上不是，并非没有其他许可证。
额外安装的费用每月将超过 1,000 美元。
回答by Taryn
Yes, you can install SSRS and a SQL Server database on different servers. While the default installation tries to install both, you can select to install them separately.
是的，您可以在不同的服务器上安装 SSRS 和 SQL Server 数据库。虽然默认安装尝试安装两者，但您可以选择单独安装它们。
MSDN links:
MSDN 链接：
Considerations for Installing Reporting Services
Installing SQL Server Reporting Services
From MSDN article Considerations for Installing Reporting Services:
来自 MSDN 文章安装 Reporting Services 的注意事项：
Select Database Engine Services in the Feature Selection page to host the report server databases. Reporting Services requires a local or remote instance of SQL Server 2005 or SQL Server 2008 Database Engine to host the report server databases.If you install an instance of the Database Engine concurrently with Reporting Services, you can eliminate a post-Setup task by installing the default configuration, which creates and configures the report server databases automatically. In addition to hosting the report server databases, SQL Server relational databases can also be a source of data for reports and models.
在“功能选择”页中选择“数据库引擎服务”以承载报表服务器数据库。Reporting Services 需要 SQL Server 2005 或 SQL Server 2008 数据库引擎的本地或远程实例来承载报表服务器数据库。如果与 Reporting Services 同时安装数据库引擎的实例，则可以通过安装默认配置来消除安装后任务，该配置会自动创建和配置报表服务器数据库。除了托管报表服务器数据库之外，SQL Server 关系数据库还可以作为报表和模型的数据源。
回答by Rafael Dontal Gon?alez
You could install SSRS in a new server, but to do so you would need a new license for this other server.
您可以在新服务器上安装 SSRS，但要这样做，您需要为这台其他服务器获得新许可证。
From Microsoft SQL Server 2014 Licensing Guide:
来自 Microsoft SQL Server 2014 许可指南：
"The software components of a single SQL Server 2014 license cannot be separated for use in more than one OSE. If these components are running on a server other than the main database server, then an additional license is required for each additional OSE in which they are installed. For example, if the SQL Server DB is deployed in one OSE and SQL Server RS is deployed in another, both OSEs must be fully licensed for SQL Server 2014 accordingly."
“单个 SQL Server 2014 许可证的软件组件不能分开用于多个 OSE。如果这些组件在主数据库服务器以外的服务器上运行，则它们所在的每个额外 OSE 都需要一份额外的许可证已安装。例如，如果 SQL Server DB 部署在一个 OSE 中，而 SQL Server RS 部署在另一个 OSE 中，则这两个 OSE 必须相应地获得 SQL Server 2014 的完全许可。”
Link to download the guide:
下载指南的链接：
