I set up SQL Server 2008 R2 along with SSRS on a Windows 2008 server--let's call it "SQLDB"--and all's working fine. I'm able to upload reports that are pulling data from the SQLDB databases. There is no problem.
However, the operations dept. now tells me that a server with SQL Server installed absolutely will not be made available to the users and so I will need a separate SSRS 2008 R2 server (named "SQLRS") that pulls data from SQLDB databases. Basically,
I need to stop using SSRS on SQLDB and start using SSRS on SQLRS. Makes sense to me, although I've never done this.
I'm confused about what services and components of SQL Server 2008 R2 need to be installed on which server(s). Could somebody please point me to a page that explains it thoroughly or, if it's fairly simple, explain it for me here?
For instance, "SQLDB" has SSAS, SSIS, database engine, SQL Browser, Management Tools, and SQL Agent installed.
On "SQLRS", I installed SSRS, database engine, SQL Agent, SQL Browser, Management Tools, and SQL Agent. Was it necessary to install the database engine, considering the data to be pulled is on "SQLDB"? I read that the Agent is only required for
subscriptions, but what about SQL Browser? Is it only required on s
View Complete Post