can't call method CreateReport under asp.net

CreateReport throws an error saying that user IUSR_XXXXX doesn't have
permisssions
to run this method.
So,
1) I went to ReportServices roles and anded a new group for IUSR_XXXXX user
2) Assigned ReportserverSysadmin role for the new group.
3) Also set db_owner permissions for the IUSR_XXXXX user in ReportService
related databases on
my local instance of MS SQL.
No results. Still can't call method CreateReport().
Any ideas ?
Thanks
Paul
PS. BTW this method works fine from *.rss script that is running under
local Admin account.You need to give this user permission in the specific folder that they are
trying to create the report in. The SysAdmin role is just for system level
operations, not item specific operations.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> permisssions
> to run this method.
> So,
> 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
user
> 2) Assigned ReportserverSysadmin role for the new group.
> 3) Also set db_owner permissions for the IUSR_XXXXX user in
ReportService
> related databases on
> my local instance of MS SQL.
> No results. Still can't call method CreateReport().
> Any ideas ?
> Thanks
> Paul
> PS. BTW this method works fine from *.rss script that is running under
> local Admin account.
>
>|||Also, try enabling impersonation for your ASP.NET app. See:
http://blogs.msdn.com/bryanke/archive/2004/03/03/83345.aspx
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> permisssions
> to run this method.
> So,
> 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
user
> 2) Assigned ReportserverSysadmin role for the new group.
> 3) Also set db_owner permissions for the IUSR_XXXXX user in
ReportService
> related databases on
> my local instance of MS SQL.
> No results. Still can't call method CreateReport().
> Any ideas ?
> Thanks
> Paul
> PS. BTW this method works fine from *.rss script that is running under
> local Admin account.
>
>|||Hi Daniel
Thanks for answering
But how to do it through report server UI ?
or should I use some API function call ?
Thanks
Paul
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ugZW9KcdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> You need to give this user permission in the specific folder that they are
> trying to create the report in. The SysAdmin role is just for system
level
> operations, not item specific operations.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "pTsy" <ptsygura@.bna.com> wrote in message
> news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> > CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> > permisssions
> > to run this method.
> >
> > So,
> > 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
> user
> > 2) Assigned ReportserverSysadmin role for the new group.
> > 3) Also set db_owner permissions for the IUSR_XXXXX user in
> ReportService
> > related databases on
> > my local instance of MS SQL.
> >
> > No results. Still can't call method CreateReport().
> > Any ideas ?
> > Thanks
> > Paul
> >
> > PS. BTW this method works fine from *.rss script that is running under
> > local Admin account.
> >
> >
> >
> >
>|||Go to report manager as a local admin, click on the property tab, click on
the security sub-tab and there you can set permissions. You can do this
for any item in the catalog.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:uW47l1veEHA.1724@.TK2MSFTNGP10.phx.gbl...
> Hi Daniel
> Thanks for answering
> But how to do it through report server UI ?
> or should I use some API function call ?
> Thanks
> Paul
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ugZW9KcdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> > You need to give this user permission in the specific folder that they
are
> > trying to create the report in. The SysAdmin role is just for system
> level
> > operations, not item specific operations.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "pTsy" <ptsygura@.bna.com> wrote in message
> > news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> > > CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> > > permisssions
> > > to run this method.
> > >
> > > So,
> > > 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
> > user
> > > 2) Assigned ReportserverSysadmin role for the new group.
> > > 3) Also set db_owner permissions for the IUSR_XXXXX user in
> > ReportService
> > > related databases on
> > > my local instance of MS SQL.
> > >
> > > No results. Still can't call method CreateReport().
> > > Any ideas ?
> > > Thanks
> > > Paul
> > >
> > > PS. BTW this method works fine from *.rss script that is running
under
> > > local Admin account.
> > >
> > >
> > >
> > >
> >
> >
>