Thursday, March 29, 2012

Access denied and no files...

I performed an install of SSRS and SharePoint as noted in this document...
http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx
...with one exception I installed everything (SQL Server, Reporting
Services, and SharePoint) on the same server (single server install, don't
worry it is purely a dev box on an isolate test network, I would never do
this in production). I have rebuilt the server twice and worked though this
document each time.
Every time I get to Step 12 (on page 38-39 of the document), I try opening
the reporting services web site using the server name (e.g.
http://servername:8080/Reportserver). I get a login prompt and access denied
after three attempts. When I try to access it through localhost (e.g.
http://localhost:8080/ReportServer), I do not get the login prompt, but I do
get the typical directory browsing page with no files are listed.
All the ACLs (NTFS permissions) are set to allow Full Control for the local
admins and the three accounts being used per the document are in local admins
group. The Local admins group and the three accounts have SysAdmin rights on
SQL server.
I have done many SSRS installs but have yet to experience and issue like
this. I would greatly appreciate any of you pointing me in the right direct
to check settings. Any helpIt sounds like you are running into the Loopback Checking that was put into
place by Windows Server 2003 SP1. Follow the instructions in the KB article
listed below and that should solve your issue.
http://support.microsoft.com/kb/896861
Follow the steps under "Method 1" and see if that works.
Don't forget to reboot for it to kick in.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment