I am not sure where to send this request. I am trying to help a business teacher whose reports no longer run. When going to pull the report from the page the following error is given. Where would I go to resolve this? The report was supposedly working last week but I am not familiar with IIS/MSSQL enough to understand the stacktrace. Thanks CTEC <code> Server Error in '/Database' Application. The remote server returned an error: (403) Forbidden. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Net.WebException: The remote server returned an error: (403) Forbidden. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [WebException: The remote server returned an error: (403) Forbidden.] System.Net.HttpWebRequest.CheckFinalStatus() +680 System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult) +139 System.Net.HttpWebRequest.GetResponse() +249 System.Xml.XmlDownloadManager.GetNonFileStream(Uri uri, ICredentials credentials) +65 System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials credentials) +94 System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn) +55 System.Xml.Schema.DtdParser.ParseDocTypeDecl() +741 System.Xml.Schema.DtdParser.Parse() +61 System.Xml.XmlTextReader.ParseDtd(XmlScanner scanner) +83 System.Xml.XmlTextReader.ParseTag() +1379 System.Xml.XmlTextReader.ParseRoot() +262 System.Xml.XmlTextReader.Read() +127 System.Xml.XmlValidatingReader.ReadWithCollectTextToken() +146 System.Xml.XmlValidatingReader.Read() +26 System.Xml.XPath.XPathDocument.ReadChildNodes(XPathContainer parent, String parentBaseUri, XmlReader reader, PositionInfo positionInfo) +835 System.Xml.XPath.XPathDocument.Load(XmlReader reader) +146 System.Xml.Xsl.Compiler.LoadDocument(XmlTextReader reader) +107 System.Xml.Xsl.XslTransform.Load(String url, XmlResolver resolver) +144 System.Xml.Xsl.XslTransform.Load(String url) +26 LDPN.Academy.Reports.AbsenceReport.Page_Load(Object sender, EventArgs e) +1188 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 Version Information: Microsoft .NET Framework Version:1.1.4322.2443; ASP.NET Version:1.1.4322.2470 </code>

Hi ctec, This is a general error message. There might be many factors to cause the issue. Here are possible causes that i am aware of: 1. Some configuration did not do. Open the Reporting Services Configuration Manager tool to check all the configuration, see http://msdn.microsoft.com/en-us/library/aa337424(v=SQL.90).aspx on Reporting Services Tools. 2. In the reporting services confuration manager tool, rebuild the virtual directory of report manager/report server. 3. If the report server enables SSL, recreate a certificate and then rebind it to report server. If the issue persists, provide more details here so that we could do further research. thanks, Jerry

Jerry, Thanks. the msdn link shows the information for SQL 2005 how would I do this for SQL 2000? I do not see the same options available. Once I fix this error I can update to a later version but I don't want to do so until it works obviously. More details = the reports suddenly stopped working. The teacher has no idea when it occurred. Looking at the server it is running SQL 2000, and has visual studio 2003. What other information would be helpful? Ctec

Hi CTEC, Can you send the .rdl file. That should help.

I do not have an .rdl file on the server. where would I locate this?

Well you can download that from the report manager itself where the report is deployed.

Suman, The report is deployed from an internal webpage. There is a calendar to choose the date for the report and then a button to generate the report. Any clues would be helpful. Thanks CTEC