rsAccessDeniedToSecureData

I've installed a fresh load of SQL Server 2005 onto a Windows 2000 server, including all the trimmings with SS2005.

Reporting Services 2005 is the main thing I want to initially check out, but I can't get it to work.

In the 'Reporting Services Configuration' it shows the 'Web Service Identity' as a blank grey box which can not be edited. I can't help but think this might be where the issue is.

I looked at this thread, as it describes the exact same problem, but the solution did not work for me.

The RS service will start up, but then when I navigate to http://localhost/reportserver or http://localhost/reports it gives me the following error:

Reporting Services Error

Answer this question

rsAccessDeniedToSecureData

Michael Barbu
In Internet Information Services:

Open up the properties to the Reports website. Click the asp.net tab, is an ASP.net version selected
SillaS
Thanks for your reply again.

1. There was no problem accessing machine.config with 'Everyone' able to access it. But still had the same issue. Also checked it with FileMon, no failures.

2. I'm not sure about the Whidbey part. I checked the value you suggested and this was the entry:

<system.web>
<processModel autoConfig="true"/>
Gafrage
Thanks for your reply.

I have run SysInternals RegMon, but it showed nothing being denied. All keys opened fine, there was not even an entry for anything with 'WinMgmt.exe'.

Do you think it could possibly be something within the ASP settings

This is the log with ASP as the filter word:

1 10:40:10 IEXPLORE.EXE:4480 QueryValue HKCU\Software\Microsoft\Internet Explorer\TypedURLs\url5 SUCCESS "http://ap43-0029/reports/Pages/Folder.aspx"
2 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.aspx NOT FOUND
3 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\.aspx NOT FOUND
4 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\.aspx SUCCESS Access: 0x2000000
5 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\.aspx SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\.aspx
6 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\.aspx NOT FOUND
7 10:40:15 IEXPLORE.EXE:4480 QueryValue HKCR\.aspx\(Default) SUCCESS "VisualStudio.aspx.8.0"
8 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0 NOT FOUND
9 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\VisualStudio.aspx.8.0 SUCCESS Access: 0x2000000
10 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\VisualStudio.aspx.8.0 SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\VisualStudio.aspx.8.0
11 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0\CurVer NOT FOUND
12 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\VisualStudio.aspx.8.0\CurVer NOT FOUND
13 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\VisualStudio.aspx.8.0 SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\VisualStudio.aspx.8.0
14 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0 NOT FOUND
15 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\VisualStudio.aspx.8.0 SUCCESS Access: 0x2000000
16 10:40:15 IEXPLORE.EXE:4480 CloseKey HKCR\VisualStudio.aspx.8.0 SUCCESS
17 10:40:15 IEXPLORE.EXE:4480 CloseKey HKCR\.aspx SUCCESS
18 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\VisualStudio.aspx.8.0 SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\VisualStudio.aspx.8.0
19 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0 NOT FOUND
20 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\VisualStudio.aspx.8.0 SUCCESS Access: 0x2000000
21 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\VisualStudio.aspx.8.0 SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\VisualStudio.aspx.8.0
22 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0\shell\edit NOT FOUND
23 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\VisualStudio.aspx.8.0\shell\edit NOT FOUND
24 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\VisualStudio.aspx.8.0 SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\VisualStudio.aspx.8.0
25 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0\shell\edit NOT FOUND
26 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\VisualStudio.aspx.8.0\shell\edit NOT FOUND
27 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\VisualStudio.aspx.8.0 SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\VisualStudio.aspx.8.0
28 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\VisualStudio.aspx.8.0 NOT FOUND
29 10:40:15 IEXPLORE.EXE:4480 QueryValue HKCR\VisualStudio.aspx.8.0\BaseClass NOT FOUND
30 10:40:15 IEXPLORE.EXE:4480 CloseKey HKCR\VisualStudio.aspx.8.0 SUCCESS
31 10:40:15 IEXPLORE.EXE:4480 CloseKey HKCR\VisualStudio.aspx.8.0 SUCCESS
32 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\.aspx\OpenWithList NOT FOUND
33 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCR\.aspx\OpenWithList SUCCESS Access: 0x20019
34 10:40:15 IEXPLORE.EXE:4480 QueryKey HKCR\.aspx\OpenWithList SUCCESS Name: \REGISTRY\MACHINE\SOFTWARE\CLASSES\.aspx\OpenWithList
35 10:40:15 IEXPLORE.EXE:4480 OpenKey HKCU\Software\Classes\.aspx\OpenWithList NOT FOUND
36 10:40:15 IEXPLORE.EXE:4480 EnumerateKey HKCR\.aspx\OpenWithList SUCCESS Name: devenv.exe
37 10:40:15 IEXPLORE.EXE:4480 EnumerateKey HKCR\.aspx\OpenWithList NO MORE ENTRIES
38 10:40:15 IEXPLORE.EXE:4480 CloseKey HKCR\.aspx\OpenWithList SUCCESS
sroughley
Then the box may be disabled for IIS5.1. This is because there is no “worker process”, and the ASP.NET account is defined in machine.config file. I suggest you try 2 things:
- Use filemon to see if there are any access denied errors on the machine.config file. This is in %SystemDrive%\Windows\Microsoft.Net\Framework\v2.0.50727\Config. Grant everyone read access to verify this is not the problem.
- Make sure you installed Whidbey ASP.NET. Check if /configuration/system.web/processModel exists in machine.config.
GrandpaB
Run the SysInternals RegMon and watch for open key denied errors. If you see such an error when the Report Server is calling out to WMI, you are running in the same issue I had when installing RS on Windows 2000. In my case, the RegMon log was showing:

12477 33.38408661 WinMgmt.exe:1580 OpenKey HKLM\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0 ACCESS DENIED Access: 0x20219 NT_AUTHORITY\SYSTEM

I wasn't able to figure out why registry access is denied to Local System or a workaround. I logged this issue as a bug. If supporting Windows 2000 is a must for you, you need to escalate this issue to Microsoft Product Support.
Christopher Ireland
They allready had access.

Thank you for all your replies on this Teo. this is going to have to take a back seat for now as other priorities have come up. But I will return to this thread once I'm able to resume.

Thanks again.
David
pvphuc
Hi, Thanks for your reply.

ASP.NET version = 2.0.50727

There is also an option to choose 1.1.4322
dave2000
Is anybody able to help me further with this Still having the same issue.
ForEverLearning
I have reinstalled SQL Server 2005 and applied SP1.

It does now show an entry in the box. MACHINE NAME\ASPNET

however, as before, as soon as I try to access the report manager it brings up the error stated.

rsAccessDeniedToSecureData
Pubsnack
I was told that SQL Server 2005 SP1 should have fixed this. Have you tried it
IMBack

A couple of more things you can try as I recall:

1. Open up Computer Management. Make sure that the ASPNET account is a member of SQLServer2005ReportingServicesWebServiceUser$<machinename>$MSSQLSERVER and NT AUTHORITY\SYSTEM is a member of SQLServer2005ReportServerUser$<machinename>$MSSQLSERVER.

2. Grant these groups read/write access to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer and below.
ckrepps
When I navigate to local host it is the same error.

I tried restoring the key to the first I backed up, but that made no difference. I also tried deleting it, since I have no content on the server yet.

Neither gave any joy. :(
dtsn
What happens when you navigate to http://localhost/ReportServer . You may need to restore the encryption key as discussed here.
rsAccessDeniedToSecureData

Answer this question