Showing posts with label virtual. Show all posts
Showing posts with label virtual. Show all posts

Thursday, March 22, 2012

Authentication issue

Hello

I'm using RS 2000 and although Windows Authentication has been selected on the website and the "Reports" virtual directory, when I browse to localhost/reports I get the report manager with only Home on it and a very limited menu bar whixh exists of home, my subcriptions and help. I can't see any folders.

What am I missing?

Thanks!

What rights does your account have in the Report Catalog. What roles does it have assigned to?|||

Thanks for answering Teo

Well, it's hard to tell as I reinstalled everything but things got even worse now.
When I browse to http://localhost/reports, I get:

Access is denied.
Description: An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.

Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to ACLs). Ask the Web server's administrator to give you access to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager'.

The authentication part is ok because when I deactivate windows authentication, it's just the login box that dissapears but the error above remains so I guess the problem is not authentication related but permission related.

On the virtual directory "Reports" which is 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager', I have the following permissions set up:

Administrator Full rights
Administrators Full rights
Network Service Full rights
ASP.NET Full rights
Everyone Full rights
System Full rights

what more can you do?

|||Looks like you don't have ACL rights to the files in \Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager. Use the Reporting Services Configuration Tool to apply the default settings to the Report Manager Virtual Directory. This should give the necessary rights to the RS accounts.|||I'm afraid I will have to look for it myself because I'm using RS 2000. The configuration tool does not exist in 2000.|||

Are you connected to some corporate network or it is stand alone PC?

Are you in the Admin group on that machne? if not add yourself to the Admintrators group it should solve the problem.

|||I appologize I missed the RS 2000 part. Grant ASPNET (or Everyone) read access to the Report Manager folder.|||

Well, I reinstalled RS like 7 times and it's working now. Thank you all for the help!

Regards
Worf

Tuesday, March 20, 2012

Authentication

hey all

Not sure if I have this in the right forum - please direct me otherwise people.

This is my set-up

Windows Server 2003 (NZDEV)

Virtual Server (nzvmw1) - Visual Studio 2005

Sql Server Express Edition with Advanced Services

Tools = Reporting Services

on my computer - I have deployed a report up to the nzvmw1 server

using url nzvmw1/reports - I can see everything

my user nzdev/user (admin rights)

I have two other users - they are users on nzdev (not with admin rights)

if they use url nzvmw1/reports - the password screen comes up

nzdev/***** and password I set for them - page comes up but no folders

I don't know where else to give them permissions (and don't think I should be making everyone Admins)

can someone advise.

thanks

Jewel

Did you assign to your users report rights ? You can do it in "Home\Site settings\Configure site-wide security" (you must have admin rights to do that). In there you can assign system roles to <domain name>\<user name> or <group name>. To System roles you assign allowed report actions in "Home\Site settings\Configure System-level role definitions". You can also assign rights to every report item on your report server.

Maciej

|||

thanks heaps for the reply

On reading a little more

it seems I cannot see the pre-defined folders? to assign the roles

eg if I go to http://localhost/reports$SQLEXPRESS = HTTP error 404

which is the add most doco says to go to - to see Home folders

This has been a very messy install.

Can it be something not turned on?

thanks

Dianne

|||

ok just an update here

if I go to servername/reports - I can now assign either an admin or a user role - but I don't have the window that shows Brose, content Manager etc to actually assing further?

thanks

|||Look, these are standard configuration issues. Read some Books Online. You should find there everything you need (right now).