Error: "EXECUTE permission denied on object..."

I get this error when I try to preview a report that uses a stored procedure. The stored procedure does not exist in the database, but in the directory I run the report from. The stored procedure declares which database to use, and to create the temp table I want. Do I require special permissions on the sql db I am using to be able to create temp tables? Any help would be great, thanks!

Michael

How are you connecting to the stored procedure in a directory?

SQL Profiler may let you troubleshoot what user account and object this error message relates to.

|||

I had a developer do this awhile ago too; you require elevated permissions to create tables. Try just clearing the table rather than deleting and recreating the table every time the report is run it requires less security.

error with assebly

On preview custom assebly returns correct value - works OK, but on server i get an error like "#Error". Is it possible to debug report on server?
Thanks.Your custom assembly may not have permissions to do what you want it to do.
You'll need to edit the rssrvpolicy.config file and give it appropriate
permissions. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:4AE2405E-5DB7-4B48-82B8-4F8846112038@.microsoft.com...
> On preview custom assebly returns correct value - works OK, but on server
i get an error like "#Error". Is it possible to debug report on server?
> Thanks.
>

Error while previewing the report in Visual Studio 2005

Hi there,

The Visual Studio 2005 asks me to send an error report each time when I try to preview the reports. The reports are created in report server project in Visual Studio 2005.

Does anyone know why this is a problem?

Thanks

As a first step I would recommend to install SQL Server 2005 SP1 (http://www.microsoft.com/sql/sp1.mspx).

If you still encounter problems, you may want to try to directly publish the report to a report server and see if there are any publishing warnings or errors. Also posting the RDL file on this forum may help in further diagnosis.

-- Robert

|||

Thanks Robert, will get back if I still have any problems