Issues with Report Manager on both a web server and the report server?

My reports have been run off of a combined IIS/SQL server. I have a new application, which is using the SQL server, but runs on its own web server. The developer would like to deploy his reports to the new IIS server. Are there any issues with just installing a copy of the Report Manager on the new IIS server and putting reports there while continuing to run the original application on the combined server?

TIA

Daniel

Hi,

From your description, it seems that you want to deploy your reporting service on other server than the server with SQLServer, right?

I'm afraid you have to install components for SQLServer reporting service on that new IIS. Only n this way, you can re-configure the settings in SQL Server Reporting Services Configuration, including Web Service Identity, report server and report manager virtual directory, also the new database server's information. After that , you can run your reporting service with other database servers.

For more information on each components of Reporting service, see:

http://msdn2.microsoft.com/en-us/library/ms155792.aspx

Thanks.

|||

Michael,

I want to deploy report manager on two servers, the SQL server itself and on another server running just as a web server. I have not found a definitive answer, but based on what I have found I am thinking you can only have one report manager set up.

Regards,

Daniel

|||

Hi,

the SQL server itself and on another server running just as a web server.

No matter how many machines you want to run your Report Manager, you should install the SQLServer client component to enable the SQL Report manager. (connecting a remote database).

sql