Friday, February 10, 2012

Can't connect Report server at management studio and report manager at Explorer

I am using 2003 Server standard Edition (5.2.3790), SQL SERVER 2005 (9.00.1399) and IIS 6.0

When I tried to open the report manger at Explorer as typed http://servername/reports, http://localhost/reports, http://127.0.0.1/reports

I got an error : HTTP 404 : file not found

At testing connection on SQL server management studio, got an error -> the request failed with HTTP 404 status (Microsoft.sqlserver.management.UI.RSClient)

My configuration details as belows;

1. IIS 6.0 configuration

I made reports and reportserver virtual directory on Default web sites.

<<Default web site>>

Web site > Port 80, IP address : all unassigned

Directory security > checked Enable anonymous access

<< Report manager>>

Virtual directory >C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

ASP.net -> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config

(enable default content pages : home.aspx)

Directory Security > checked at Integrated Windows Authentication

<<Report server>>

Virtual directory > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

ASP.net -> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config

(enable default content pages : default.aspx, default.htm.default.asp, index.htm,iisstart.htm)

Directory Security > checked at Integrated Windows Authentication

2. Report server configuration

<<RSWebApplication.config>> file

<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>Reportserver</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

<<rsreportserver.config>> file

<Service>
<UrlRoot>http://<servername>/reportserver</UrlRoot>
<UserName></UserName>
<Password></Password>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
</Service>

3. SQL Server Management studio configuration

Authentication : Window Authentication

Please help me out. Should I reinstalled reporting service into SQL SERVER 2005?

thanks,

Eunsu

The URL you want to connect to is http://servername/reportserver.

|||Sure, I also tried to connect reportserver by url http://servername/reportserver, but got the same error.|||

Have you tried running the configuration tool? It should walk you through making sure that the server is properly configured.

Start->Microsoft SQL Server 2005->Configuration Tools->Reporting Services Configuration

|||

In advance, thanks for your concern

I've already done by reporting service configuration tool and checked every condition that was OK. But the result was same error messages.

Do I reinstall reporting service ?

No comments:

Post a Comment