SQl 2008 Express Reporting Services Error

Question

Post reply

SQl 2008 Express Reporting Services Error

r2d4cp3o

Old Hand

Points: 374
More actions
April 28, 2009 at 6:29 pm

#203443

In the Reporting Service Configuration Manager on the Report Manager URL tab if I click the hyperlink, a login box pops up but no matter what I key in as a user nothing works. The error is:
Server Error in '/Reports_P4SCREAMER' Application.
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 Access Control Lists). Ask the Web server's administrator to give you access to 'c:\Program Files\Microsoft SQL Server 2008 Express\MSRS10.P4SCREAMER\Reporting Services\ReportManager\home.aspx'.
Version Information: Microsoft .NET Framework Version:; ASP.NET Version:2.0.50727.3053
----------
This is on a Windows XP Pro SP2 box.
Isn't is supposed to be .NET 3.5 NOT 2.0...
Any ideas?

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

John H Marsh SSChampion Points: 11671 More actions · Answer 1

Hello,

Does the workaround mentioned in the following thread resolve your issue:-

http://social.msdn.microsoft.com/Forums/de-DE/sqlreportingservices/thread/8699009d-dd56-4a21-b2a3-440b49acab06

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

r2d4cp3o Old Hand Points: 374 More actions · Answer 2

I changed it a while ago. here is the Auth section

true

is this correct?

r2d4cp3o Old Hand Points: 374 More actions · Answer 3

Ok XML does not show in the above post. How do I make it show?

John H Marsh SSChampion Points: 11671 More actions · Answer 4

Hello again,

XML Should be visible if you surround it with the "Code" tags. Which are selectable from the IFCode option. For example:-

VisibleXML

Just to check, did you restart the Services after making the change?

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

r2d4cp3o Old Hand Points: 374 More actions · Answer 5

Just stopped and started all 4 SQL services that were running.

What user name should I be keying in when the login box pops up after I click the Reporting Services URL? I'm using my local user account. There seems to be something completely wrong with the setup of this, since no matter what I try, nothing works.

John H Marsh SSChampion Points: 11671 More actions · Answer 6

Can you view the properties of the folder “'c:\Program Files\Microsoft SQL Server 2008 Express\MSRS10.P4SCREAMER\Reporting Services\ReportManager\” via Windows Explorer?

If so, check which users and groups have access to the folder, and ensure that your login has at least read and execute permissions.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

r2d4cp3o Old Hand Points: 374 More actions · Answer 7

my login has permission and I also added

SQLServerReportServerUser$... and ASP.NET user at one point reading something somewhere else.

r2d4cp3o Old Hand Points: 374 More actions · Answer 8

here are the Authentication tags in rsreportserver.config file. There are of them

true

r2d4cp3o Old Hand Points: 374 More actions · Answer 9

I think the REAL problem with this is security is so tight today and this computer has or had so much different software such as VB6, VB.NET 2002, 2003, 2005, 2008; SQL Server 2000, 2005 Express, Mobil edition, SQL 2008 Express, AutoCAD, MS Office Developer and so much more, that it can't figure out what to do. So I would suspect the only way to fix it would be to Reformat the HD and start all over. Which I’m not going to do at this point.

So I’m ending this post. Thanks

scott_t_mark Newbie Points: 1 More actions · Answer 10

I know you said you closed this task, but I am running into the same issue and for the life of me can't figure out how to access Report Manager.

This is on a Windows XP Pro (MCE) laptop.

Thanks for any help!