access denied when deploying to prod

I'm trying to deploy my reports to my production server and I'm getting
'rsAccessDenied:The permissions granted to user 'domain\me' are insufficient
for performing this operation'
I asked my dba to give me full permissions on the reportServer and
ReportServerTempDB databases in production AND the reportmanager,
reportserver folders in Reporting Services folder and neither of these helped
me get the access I need. Any help would be appreciated!
Thanks!You do not need to do any of those things and shouldn't. Do not give any
permissions directly through IIS or SQL Server. RS has its own role based
security. You need to be part of a group that is given the appropriate role.
This is done from Report Manager. What I do is create a local group and add
domain users and groups to that local group then I assign that local group
to the appropriate role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Carrie" <Carrie@.discussions.microsoft.com> wrote in message
news:BBAEBB42-7177-4789-809B-937B80FE97C5@.microsoft.com...
> I'm trying to deploy my reports to my production server and I'm getting
> 'rsAccessDenied:The permissions granted to user 'domain\me' are
> insufficient
> for performing this operation'
> I asked my dba to give me full permissions on the reportServer and
> ReportServerTempDB databases in production AND the reportmanager,
> reportserver folders in Reporting Services folder and neither of these
> helped
> me get the access I need. Any help would be appreciated!
> Thanks!|||Report Manager on the Production machine or local machine? Locally I gave
myself all 4 roles and still no dice. And on the production machine all I see
is the empty Home folder and links for Site Subscriptions?
Thanks for the help!
"Bruce L-C [MVP]" wrote:
> You do not need to do any of those things and shouldn't. Do not give any
> permissions directly through IIS or SQL Server. RS has its own role based
> security. You need to be part of a group that is given the appropriate role.
> This is done from Report Manager. What I do is create a local group and add
> domain users and groups to that local group then I assign that local group
> to the appropriate role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Carrie" <Carrie@.discussions.microsoft.com> wrote in message
> news:BBAEBB42-7177-4789-809B-937B80FE97C5@.microsoft.com...
> > I'm trying to deploy my reports to my production server and I'm getting
> > 'rsAccessDenied:The permissions granted to user 'domain\me' are
> > insufficient
> > for performing this operation'
> > I asked my dba to give me full permissions on the reportServer and
> > ReportServerTempDB databases in production AND the reportmanager,
> > reportserver folders in Reporting Services folder and neither of these
> > helped
> > me get the access I need. Any help would be appreciated!
> > Thanks!
>
>|||Production machine. You have to be a member already of the appropriate role
to be able to assign roles. Anyone in the local admin group (of your
production server) is in the correct role. This is why in your development
machine you didn't have to do anything special. If someone who is
administrator for the machine goes to Report Manager and sees what you see
then something different is happening. If the websites (ReportServer and
Reports) have been set in IIS as anonymous access then everyone is anonymous
and no-one has rights to administer RS. That might be your problem. Or at
least one of your problems.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Carrie" <Carrie@.discussions.microsoft.com> wrote in message
news:97A04826-4ECC-4FF0-A6D9-252F0068C131@.microsoft.com...
> Report Manager on the Production machine or local machine? Locally I gave
> myself all 4 roles and still no dice. And on the production machine all I
> see
> is the empty Home folder and links for Site Subscriptions?
> Thanks for the help!
> "Bruce L-C [MVP]" wrote:
>> You do not need to do any of those things and shouldn't. Do not give any
>> permissions directly through IIS or SQL Server. RS has its own role based
>> security. You need to be part of a group that is given the appropriate
>> role.
>> This is done from Report Manager. What I do is create a local group and
>> add
>> domain users and groups to that local group then I assign that local
>> group
>> to the appropriate role.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Carrie" <Carrie@.discussions.microsoft.com> wrote in message
>> news:BBAEBB42-7177-4789-809B-937B80FE97C5@.microsoft.com...
>> > I'm trying to deploy my reports to my production server and I'm getting
>> > 'rsAccessDenied:The permissions granted to user 'domain\me' are
>> > insufficient
>> > for performing this operation'
>> > I asked my dba to give me full permissions on the reportServer and
>> > ReportServerTempDB databases in production AND the reportmanager,
>> > reportserver folders in Reporting Services folder and neither of these
>> > helped
>> > me get the access I need. Any help would be appreciated!
>> > Thanks!
>>|||Thank you, now I'm on the right track. That would ahve taken me a long time
to figure out.
Thanks again!
"Bruce L-C [MVP]" wrote:
> Production machine. You have to be a member already of the appropriate role
> to be able to assign roles. Anyone in the local admin group (of your
> production server) is in the correct role. This is why in your development
> machine you didn't have to do anything special. If someone who is
> administrator for the machine goes to Report Manager and sees what you see
> then something different is happening. If the websites (ReportServer and
> Reports) have been set in IIS as anonymous access then everyone is anonymous
> and no-one has rights to administer RS. That might be your problem. Or at
> least one of your problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Carrie" <Carrie@.discussions.microsoft.com> wrote in message
> news:97A04826-4ECC-4FF0-A6D9-252F0068C131@.microsoft.com...
> > Report Manager on the Production machine or local machine? Locally I gave
> > myself all 4 roles and still no dice. And on the production machine all I
> > see
> > is the empty Home folder and links for Site Subscriptions?
> > Thanks for the help!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You do not need to do any of those things and shouldn't. Do not give any
> >> permissions directly through IIS or SQL Server. RS has its own role based
> >> security. You need to be part of a group that is given the appropriate
> >> role.
> >> This is done from Report Manager. What I do is create a local group and
> >> add
> >> domain users and groups to that local group then I assign that local
> >> group
> >> to the appropriate role.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Carrie" <Carrie@.discussions.microsoft.com> wrote in message
> >> news:BBAEBB42-7177-4789-809B-937B80FE97C5@.microsoft.com...
> >> > I'm trying to deploy my reports to my production server and I'm getting
> >> > 'rsAccessDenied:The permissions granted to user 'domain\me' are
> >> > insufficient
> >> > for performing this operation'
> >> > I asked my dba to give me full permissions on the reportServer and
> >> > ReportServerTempDB databases in production AND the reportmanager,
> >> > reportserver folders in Reporting Services folder and neither of these
> >> > helped
> >> > me get the access I need. Any help would be appreciated!
> >> > Thanks!
> >>
> >>
> >>
>
>|||Hey Bruce,
I am getting the same problem when i try to run report on my local machine,
I am getting error mymachinename\ASPNet account do not have sufficient
permissions.
I will really appreciate if you can help me in this.
Thanks
Reddy
"Carrie" wrote:
> Thank you, now I'm on the right track. That would ahve taken me a long time
> to figure out.
> Thanks again!
> "Bruce L-C [MVP]" wrote:
> > Production machine. You have to be a member already of the appropriate role
> > to be able to assign roles. Anyone in the local admin group (of your
> > production server) is in the correct role. This is why in your development
> > machine you didn't have to do anything special. If someone who is
> > administrator for the machine goes to Report Manager and sees what you see
> > then something different is happening. If the websites (ReportServer and
> > Reports) have been set in IIS as anonymous access then everyone is anonymous
> > and no-one has rights to administer RS. That might be your problem. Or at
> > least one of your problems.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Carrie" <Carrie@.discussions.microsoft.com> wrote in message
> > news:97A04826-4ECC-4FF0-A6D9-252F0068C131@.microsoft.com...
> > > Report Manager on the Production machine or local machine? Locally I gave
> > > myself all 4 roles and still no dice. And on the production machine all I
> > > see
> > > is the empty Home folder and links for Site Subscriptions?
> > > Thanks for the help!
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> You do not need to do any of those things and shouldn't. Do not give any
> > >> permissions directly through IIS or SQL Server. RS has its own role based
> > >> security. You need to be part of a group that is given the appropriate
> > >> role.
> > >> This is done from Report Manager. What I do is create a local group and
> > >> add
> > >> domain users and groups to that local group then I assign that local
> > >> group
> > >> to the appropriate role.
> > >>
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "Carrie" <Carrie@.discussions.microsoft.com> wrote in message
> > >> news:BBAEBB42-7177-4789-809B-937B80FE97C5@.microsoft.com...
> > >> > I'm trying to deploy my reports to my production server and I'm getting
> > >> > 'rsAccessDenied:The permissions granted to user 'domain\me' are
> > >> > insufficient
> > >> > for performing this operation'
> > >> > I asked my dba to give me full permissions on the reportServer and
> > >> > ReportServerTempDB databases in production AND the reportmanager,
> > >> > reportserver folders in Reporting Services folder and neither of these
> > >> > helped
> > >> > me get the access I need. Any help would be appreciated!
> > >> > Thanks!
> > >>
> > >>
> > >>
> >
> >
> >