troubleshooting Question

Sql Server 2005 - Reporting Services Installation / Connection / Security on Vista Ultimate

Avatar of chupaul
chupaulFlag for United States of America asked on
Microsoft SQL Server 2005Windows Vista
6 Comments1 Solution2678 ViewsLast Modified:
Hi Experts,

Problem: I can't connect to Sql Server Reporting Services SSRS from Sql Server Management Studio and connect access the Report website.

Background:
I originally installed Sql Server 2005 as a default instance but did not configure IIS 7 properly
and SSRS did NOT install.
So, I reinstalled Sql 2005 as a named instance: Sql2005 after configuring IIS 7 for SSRS.
and now SSRS is installed and the websites show in IIS 7 but I can't connect to them.

http://localhost/reports$sql2005 
http://localhost/reportserver$sql2005
  I believe they both are setup with Windows Authentication and anonymous access is disabled

Sql Server 2005 Surface Area Configuration
   Reporting Services
      SQL2005 ( instance )
        Windows Integrated Security  <============ click for error

The request failed with HTTP status 403:  Forbidden. (SQLSAC)

Report Services is running with the local system account.

Did service pack 2 break something ?

A similiar problem was reported here without a true fix:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1820782&SiteID=17

Thanks, Paul



Dell Laptop running Vista sp1 , Sql Server 2005 sp2

I need some suggestions on security configuration.


Thanks, Paul
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros