report manager execution problem

Hello!
I have a problem making the report manager create a snopshot of a report.
It generates the report if the execution option is set to "Render this
report with the most recent data", but does not generate otherwise.
I left it over night to finish a snapshot, and it still gave me the error
that the report is not ready for viewing.
I have limited permissions on the server and on the datasource DB. I have
publisher's permissions on the server and query select and store procedure
execute permissions on the DB.
I have set up the datasource to use stored Credentials, since the DB is on a
different server.
What can I do?
Thanks for your help.Hello!
Never mind the last question.
It suddenly started generating the snapshot.
But the thin is, that when I click on "VIEW" to view the report it gives me
the following error:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
EXECUTE permission denied on object 'sp_verify_job_identifiers', database
'msdb', owner 'dbo'. SELECT permission denied on object 'sysjobs', database
'msdb', owner 'dbo'. EXECUTE permission denied on object
'xp_sqlagent_enum_jobs', database 'master', owner 'dbo'.
But If I go to history I can view the snapshot.
How do I make te snapshot appear on the screen when I click "VIEW"?
Thanks
"Anton" wrote:
> Hello!
> I have a problem making the report manager create a snopshot of a report.
> It generates the report if the execution option is set to "Render this
> report with the most recent data", but does not generate otherwise.
> I left it over night to finish a snapshot, and it still gave me the error
> that the report is not ready for viewing.
> I have limited permissions on the server and on the datasource DB. I have
> publisher's permissions on the server and query select and store procedure
> execute permissions on the DB.
> I have set up the datasource to use stored Credentials, since the DB is on a
> different server.
> What can I do?
> Thanks for your help.|||This fixed My Problem
Solution
The problem is occurring due to missing permissions on the SQL server. This can occur because the database was restored or moved as the permissions are applied during installation by default. The following query can be run to apply the correct permissions. This query does not need to be run on a specific database, just open Management Studio and select ?new query? from the file menu:
USE master
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole
GO
USE msdb
GO
-- Permissions for SQL Agent SP's
GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole
GO
GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole
GO
GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole
GO
No restart is required, once the above query has been run Delivery Schedules will function correctly.
From http://www.developmentnow.com/g/115_2005_6_0_0_534593/report-manager-execution-problem.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com