Schedule problem with remote SQL instance.

Im running RS on Windows 2003 server, connecting to a remote instance of SQL.
When I try to set up a schedule for any report, i get...
"The SQL Agent service is not running. This operation requires the SQL Agent
service. (rsSchedulerNotResponding)"
I know its not finding any local sql agent on the server RS is running on,
what im wondering is if there is a way to hack it to use the SQL agent on a
remote SQL server to schedule these reports.
Thanks!i have the same problem..Did u find any solution?
"Jason Brinkley" wrote:
> Im running RS on Windows 2003 server, connecting to a remote instance of SQL.
> When I try to set up a schedule for any report, i get...
> "The SQL Agent service is not running. This operation requires the SQL Agent
> service. (rsSchedulerNotResponding)"
> I know its not finding any local sql agent on the server RS is running on,
> what im wondering is if there is a way to hack it to use the SQL agent on a
> remote SQL server to schedule these reports.
> Thanks!|||I am pretty sure the SQL Agent message IS talking about the server with the
database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chitra" <Chitra@.discussions.microsoft.com> wrote in message
news:CAB5BEB8-36DD-490E-8AC5-15E57C19AC7B@.microsoft.com...
>i have the same problem..Did u find any solution?
> "Jason Brinkley" wrote:
>> Im running RS on Windows 2003 server, connecting to a remote instance of
>> SQL.
>> When I try to set up a schedule for any report, i get...
>> "The SQL Agent service is not running. This operation requires the SQL
>> Agent
>> service. (rsSchedulerNotResponding)"
>> I know its not finding any local sql agent on the server RS is running
>> on,
>> what im wondering is if there is a way to hack it to use the SQL agent on
>> a
>> remote SQL server to schedule these reports.
>> Thanks!