GCAnalaysis


I have a VS2005 aspx page using the ReportViewer to view a SSRS 2005 Report, all running locally on a Vista Business laptop.

I have an error because the stored procedure that it executes does not have the rights to Drop or Create Tables.

I can Preview it fine in VS2005 and I can go to ReportManager and run it OK.

This all worked fine on my XP laptop, so I am guessing that it is the Account used by IIS(7) to get to the ReportServer.

Does anyone have any clues on this

Does it use NT AUTHORITY\IUSR or NT AUTHORITY\NETWORK SERVICE, etc.

Thanks in advance

GC

Here's the message and the Tables do exist

  • An error has occurred during report processing.
    • Query execution failed for data set 'BranchHeadCountExistStartFinishTotalDS'.
      • Cannot drop the table 'ExistingStaff', because it does not exist or you do not have permission. Cannot drop the table 'Starters', because it does not exist or you do not have permission. Cannot drop the table 'Finishers', because it does not exist or you do not have permission. Cannot drop the table 'TotalFinish', because it does not exist or you do not have permission. Cannot drop the table 'StartFinish', because it does not exist or you do not have permission. The specified schema name "dbo" either does not exist or you do not have permission to use it.



Re: Stored procedure rights - Reportviewer in asp.net page - SSRS - VISTA

GCAnalaysis


Its OK I worked it out myself. It is the

NT AUTHORITY\IUSR