Reporting Services permissions installation help

I have installed Report Services 2005 Developer Edition on a Vista
machine, along with SQL Server Database Engine 2005 Developer Edition.
I am not able to perform some functions, apparently due to permissions
but I do not know what to do.
When I open the Report Manager via Internet Explorer 7, I see the top
portion; "SQL Server Reporting Services" "Home" the folder icon to the
left of those; and the links for "Home, My Subscription, and Help".
But I do not see a link for "Site Settings".
And I do not see the Report Manager Toolbar, no Contents tab or
Properties tab, and no New Folder, no New Data Source etc.
I read somewhere that this might be due to the fact that IIS is
enabled with Anonymous Access turned on. But how do I check that?
And how do I turn it off?
Also, when publishing from Visual Studio, I get:
"The permissions granted to user <machine\userX> are insufficient for
performing this operation."
Also, when I open the Management Studio and connect to the Report
Server instance, I connect and see 3 folders (Home, Security and
Shared Shedules). But Properties is grayed for the instance, and if I
try to open any Roles or System Roles, I get 'permissions are
insufficient'.
I am connecting to the instance using Windows Authentication for
UserX, and UserX is a member of the Administrators group.
When I initially installed, I installed SQL Server DB and Reporting
Services at the same time and selected Mixed Mode and specified a 'sa'
password. The Built-In-Administrators do belong to the System
Administrator's role.
Any suggestions for where to look to be able to set permissions? Or
to be able to publish?
Thanks for any help.What edition of Windows Vista are you using? Only Business, Ultimate and
Enterprise.
It does sound like you have Anonymous Auth enabled on your web site since
by default only users in the Local Administrators group have full access to
report manager.
Check the following article and make sure you followed all the steps for
installing SRS on Vista.
http://support.microsoft.com/kb/934164
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MathewLeigh@.comcast.net
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Reporting Services permissions installation help
> Followup-To: microsoft.public.sqlserver.reportingsvcs
> I have installed Report Services 2005 Developer Edition on a Vista
> machine, along with SQL Server Database Engine 2005 Developer Edition.
> I am not able to perform some functions, apparently due to permissions
> but I do not know what to do.
> When I open the Report Manager via Internet Explorer 7, I see the top
> portion; "SQL Server Reporting Services" "Home" the folder icon to the
> left of those; and the links for "Home, My Subscription, and Help".
> But I do not see a link for "Site Settings".
> And I do not see the Report Manager Toolbar, no Contents tab or
> Properties tab, and no New Folder, no New Data Source etc.
> I read somewhere that this might be due to the fact that IIS is
> enabled with Anonymous Access turned on. But how do I check that?
> And how do I turn it off?
> Also, when publishing from Visual Studio, I get:
> "The permissions granted to user <machine\userX> are insufficient for
> performing this operation."
> Also, when I open the Management Studio and connect to the Report
> Server instance, I connect and see 3 folders (Home, Security and
> Shared Shedules). But Properties is grayed for the instance, and if I
> try to open any Roles or System Roles, I get 'permissions are
> insufficient'.
> I am connecting to the instance using Windows Authentication for
> UserX, and UserX is a member of the Administrators group.
> When I initially installed, I installed SQL Server DB and Reporting
> Services at the same time and selected Mixed Mode and specified a 'sa'
> password. The Built-In-Administrators do belong to the System
> Administrator's role.
> Any suggestions for where to look to be able to set permissions? Or
> to be able to publish?
> Thanks for any help.
>|||On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> What edition of Windows Vista are you using? Only Business, Ultimate and
> Enterprise.
> It does sound like you have Anonymous Auth enabled on your web site since
> by default only users in the Local Administrators group have full access to
> report manager.
> Check the following article and make sure you followed all the steps for
> installing SRS on Vista.
> http://support.microsoft.com/kb/934164
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MathewLe...@.comcast.net
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Reporting Services permissions installation help
> > Followup-To: microsoft.public.sqlserver.reportingsvcs
> > I have installed Report Services 2005 Developer Edition on a Vista
> > machine, along with SQL Server Database Engine 2005 Developer Edition.
> > I am not able to perform some functions, apparently due to permissions
> > but I do not know what to do.
> > When I open the Report Manager via Internet Explorer 7, I see the top
> > portion; "SQL Server Reporting Services" "Home" the folder icon to the
> > left of those; and the links for "Home, My Subscription, and Help".
> > But I do not see a link for "Site Settings".
> > And I do not see the Report Manager Toolbar, no Contents tab or
> > Properties tab, and no New Folder, no New Data Source etc.
> > I read somewhere that this might be due to the fact that IIS is
> > enabled with Anonymous Access turned on. But how do I check that?
> > And how do I turn it off?
> > Also, when publishing from Visual Studio, I get:
> > "The permissions granted to user <machine\userX> are insufficient for
> > performing this operation."
> > Also, when I open the Management Studio and connect to the Report
> > Server instance, I connect and see 3 folders (Home, Security and
> > Shared Shedules). But Properties is grayed for the instance, and if I
> > try to open any Roles or System Roles, I get 'permissions are
> > insufficient'.
> > I am connecting to the instance using Windows Authentication for
> > UserX, and UserX is a member of the Administrators group.
> > When I initially installed, I installed SQL Server DB and Reporting
> > Services at the same time and selected Mixed Mode and specified a 'sa'
> > password. The Built-In-Administrators do belong to the System
> > Administrator's role.
> > Any suggestions for where to look to be able to set permissions? Or
> > to be able to publish?
> > Thanks for any help.- Hide quoted text -
> - Show quoted text -
Chris,
Excellent! Thank you thank you thank you thank you!
The article was complete and detailed and gave me exactly the
information I needed. Thanks again!|||No problem.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MathewLeigh@.comcast.net
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services permissions installation help
> Date: Tue, 09 Oct 2007 15:10:36 -0700
> On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > What edition of Windows Vista are you using? Only Business, Ultimate and
> > Enterprise.
> >
> > It does sound like you have Anonymous Auth enabled on your web site
since
> > by default only users in the Local Administrators group have full
access to
> > report manager.
> >
> > Check the following article and make sure you followed all the steps for
> > installing SRS on Vista.
> >
> > http://support.microsoft.com/kb/934164
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> Chris,
> Excellent! Thank you thank you thank you thank you!
> The article was complete and detailed and gave me exactly the
> information I needed. Thanks again!
>|||I encountered exactly the same issue on my local Vista Ultimate with
Reporting Service installed at the same time when installing SQL2005
Developer, mixed mode with sa. Later on I added my local user name (already
in OS admin group) to the fixed SQL role as sysadmin. I following your
article step by step, added Trusted Sites, until #8. When I opened IE (run as
administrator) to opened the Report Manager, I still cannot see Properties at
the Home. Only Home, Subscriptions and Help are visible. Did I miss anything?
Thanks in advance.
Hugh
"Chris Alton [MSFT]" wrote:
> No problem.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > From: MathewLeigh@.comcast.net
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: Reporting Services permissions installation help
> > Date: Tue, 09 Oct 2007 15:10:36 -0700
> >
> > On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > What edition of Windows Vista are you using? Only Business, Ultimate and
> > > Enterprise.
> > >
> > > It does sound like you have Anonymous Auth enabled on your web site
> since
> > > by default only users in the Local Administrators group have full
> access to
> > > report manager.
> > >
> > > Check the following article and make sure you followed all the steps for
> > > installing SRS on Vista.
> > >
> > > http://support.microsoft.com/kb/934164
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > >
> > >
> > >
> >
> > Chris,
> >
> > Excellent! Thank you thank you thank you thank you!
> >
> > The article was complete and detailed and gave me exactly the
> > information I needed. Thanks again!
> >
> >
>|||Hi Hugh ,
I am having the same problem using Vista Ultimate, SQL 2005 developer
edition and Report Server.
Did you resolve your issue?
I am following the article step by step no success. I do not see Site
Settings When I connect to the Report Server with Microsoft SQL Managment
Studio and right click on the server node the Properties are not available.
When I expand Home I am getting message
TITLE: Microsoft SQL Server Management Studi
----
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
The permissions granted to user 'ThePC\dimitre' are insufficient for
performing this operation. (rsAccessDenied) (Report Services SOAP Proxy
Source)
The permissions granted to user 'ThePC\dimitre' are insufficient for
performing this operation. (rsAccessDenied) (ReportingServicesLibrary)
Thanks
Mitko