Sql Server Reporting Services和多个Sharepoint Farms

时间:2021-07-07 08:20:00

I was wondering if you can have a single SSRS 2008 server be used for two different sharepoint farms? I have a SSRS 2008 box and would like to have two different reporting instances, one for each farm. We're in the middle of a transition from WSS --> MOSS, and I need to be able to support reporting on both.

我想知道您是否可以将一台SSRS 2008服务器用于两个不同的共享点服务器场?我有一个SSRS 2008框,并希望有两个不同的报告实例,每个农场一个。我们正处于从WSS过渡的过程中 - > MOSS,我需要能够支持两者的报告。

It seems when you run the sharepoint configuration on the reporting box, it asks for the farm to connect to.

当您在报告框中运行sharepoint配置时,它会要求服务器场连接到。

Any suggestions welcome.

欢迎任何建议。

Thanks,

-- Chad

1 个解决方案

#1


Reporting Services contains 2 parts, the SQL instance and the front-end.
If you want to use Reporting Services in SharePoint Integrated mode, you need to create an instance for each farm. However, both SQL instances can be in the same SQL box.
However, the reporting service front-end will need to be part of your SharePoint farm, so this part will need to be separated.

Reporting Services包含两部分,SQL实例和前端。如果要在SharePoint集成模式下使用Reporting Services,则需要为每个服务器场创建一个实例。但是,两个SQL实例都可以位于同一个SQL框中。但是,报表服务前端需要是SharePoint场的一部分,因此需要将此部分分开。

If you're planning to use the old RS webparts (iframe) or access RS webservices through code, you can do anything you want.

如果您计划使用旧的RS webparts(iframe)或通过代码访问RS webservices,您可以执行任何操作。

#1


Reporting Services contains 2 parts, the SQL instance and the front-end.
If you want to use Reporting Services in SharePoint Integrated mode, you need to create an instance for each farm. However, both SQL instances can be in the same SQL box.
However, the reporting service front-end will need to be part of your SharePoint farm, so this part will need to be separated.

Reporting Services包含两部分,SQL实例和前端。如果要在SharePoint集成模式下使用Reporting Services,则需要为每个服务器场创建一个实例。但是,两个SQL实例都可以位于同一个SQL框中。但是,报表服务前端需要是SharePoint场的一部分,因此需要将此部分分开。

If you're planning to use the old RS webparts (iframe) or access RS webservices through code, you can do anything you want.

如果您计划使用旧的RS webparts(iframe)或通过代码访问RS webservices,您可以执行任何操作。