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 ?
