SSRS 2005 on Different Server than SQL Agent?

[fuzzyocelot]

If we have Reporting Services 2005 installed on a server by itself, does the SQL agent need to be installed on that server as well in order for subscriptions to work? Or can the agent be on a separate server?

Thanks!

 

[onpnt]

You cannot (from anything I've ever read or seen) utilize a SQL Agent from a remote instance so I'm guessing no.

To be honest I wouldn't try it nor have so it may be possible. Knowing the architect of SSRS though pretty well it does not sound viable

Lets see if we get a second on that

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[mrdenny]

Correct, SQL Agent must be installed on the same server as the actual SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[fuzzyocelot]

I'm not the one who set these servers up. So I'll go talk with the person who did. Thanks to both of you for your help!