Groups | Blog | Home
all groups > sql server reporting services > june 2007 >

sql server reporting services : Access Denied Reports and ReportServer websites



Michiel W.
6/13/2007 5:41:01 AM
Hi,

I just installed a server with Windows 2003 Std SP1, with SQL Server 2000
Ent (sp4) and SQL Reporting Services 2000 Ent (sp2)

After installation i got the following error after a reboot:
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{A9E69610-B80D-11D0-B9B9-00A0C922E750}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.

That CLSID belongs to IIS Admin Service. So I gave NETWORK SERVICE local
launch and activation rights. That resolved the issue.

At next reboot the Reporting Server activated. And ready for use. So I
thought.

When I access \\servername\Reports, I get a login prompt, but whatever
credentials I give, authentication does not work. (local administrator/domain
administrator).

What i tried so far, but did not help.
- allowed Active Server Pages and ASP.Net (Web Service Extensions)
- enable anonymous access >> give "page not found"
- set read rights for IIS_WPG and replace all underlying settings
- RSWebApplication config <ReportServerUrl>servername</ReportServerUrl> ,
changed servername to localhost and FQDN
- added
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\DisableLoopbackCheck
(DWORD) = 1

What can be the problem????

--
Michiel Wouters

[MCSE 2003]
[MCSA Messaging 2003]

Michiel W.
6/13/2007 7:56:01 AM
Additional info:

when i put a test.html document in de website root of Reports i can open
\\server\Reports\test.html. (no login prompt)

So something seems te be going wrong with the home.aspx file or underlying
Reporting Components.

When enabling anonymous access, i get 'The page cannot be displayed' error.
on http://servername/Reports.
--
Michiel Wouters

[MCSE 2003]
[MCSA Messaging 2003]

Before you post, think with the brain you host ;)


[quoted text, click to view]
Michiel W.
6/13/2007 7:59:01 AM
Of course I mean:

http://servername/Reports/test.html and not \\servername\Reports\test.html :)
--
Michiel Wouters

[MCSE 2003]
[MCSA Messaging 2003]

Before you post, think with the brain you host ;)


[quoted text, click to view]
AddThis Social Bookmark Button