asked on

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

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

EugeneZ

<reinstalled Sql 2005 as a named instance: Sql2005>
with sp2 ?

check solution:
http://www.eggheadcafe.com/software/aspnet/30592593/request-failed-with-http.aspx

chupaul

ASKER

Hi EugeneZ,

Thanks for your note but I don't see have Organization Settings .... mentioned in the link is related to the problem. I don't understand that link and how it applies to the SSRS access problem.
Can you break it down for me ?

Thanks, Paul

EugeneZ

if IIS is fine:

looks like you need to review ssrs configuration:
Reporting Services Configuration Tool
http://msdn.microsoft.com/en-us/library/ms156305(SQL.90).aspx

also
Troubleshooting Reporting Services
http://msdn.microsoft.com/en-us/library/ms159135(SQL.90).aspx

chupaul

ASKER

Hi,

I went into Configuring Report Server and the problem i'm having is:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)

I specified a sa account and password and the DataBase Connection shows this warning.
Is this a WMI error or a Database Connection error ( if so why is the sa account not OK ) ?

Thanks, Paul

chupaul

ASKER

Help,

I think my install of Reporting Services is incorrect and I want to reinstall so I'm gonna follow this msdn article.

How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
http://support.microsoft.com/kb/934164

Stay Tuned...

LA Guy

ASKER CERTIFIED SOLUTION

chupaul

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial