Problem: I can't connect to Sql Server Reporting Services SSRS from Sql Server Management Studio and connect access the Report website.
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.
I believe they both are setup with Windows Authentication and anonymous access is disabled
Sql Server 2005 Surface Area Configuration
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:
Dell Laptop running Vista sp1 , Sql Server 2005 sp2
I need some suggestions on security configuration.