Error when running report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error when running report

I have configured Reporting Services on 2 servers, on one everything runs fine and reports can be generated. On the other, I get the following error when trying to run a report:
‘/’ is an unexpected token. The expected token is ‘=’. Line 9, position 33. I am not that familiar with Reporting Services so I could have made any mistake. Any help is greatly appreciated. Below is a warning in the event log
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/1/2006 5:16:38 PM
Event time (UTC): 5/1/2006 10:16:38 PM
Event ID: ced716f32f8b48f69b1329efffbcebb4
Event sequence: 76
Event occurrence: 3
Event detail code: 0 Application information:
Application domain: /LM/W3SVC/1/root/Reports-3-127909852575625000
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManager
Machine name: MSIDEVSQL Process information:
Process ID: 3656
Process name: aspnet_wp.exe
Account name: MSIDEVSQLASPNET Exception information:
Exception type: XmlException
Exception message: ‘/’ is an unexpected token. The expected token is ‘=’. Line 9, position 33. Request information:
Request URL:http://msidevsql/Reports/Reserved.R…xd?OpType=StyleSheet&Version=2005.090.1399.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 10.0.1.80
User: MNSdstevens
Is authenticated: True
Authentication Type: NTLM
Thread account name: MSIDEVSQLASPNET Thread information:
Thread ID: 6
Thread account name: MSIDEVSQLASPNET
Is impersonating: True
Stack trace: at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.ThrowUnexpectedToken(String expectedToken1, String expectedToken2)
at System.Xml.XmlTextReaderImpl.ParseAttributes()
at System.Xml.XmlTextReaderImpl.ParseElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:
FYI,
this is machine is running SQL Server 2005 Database services and Reporting Services, but also 2000 Database.
I’m not thrilled with the solution, but I have everything running now. I just recreated the Website under a different name and everything works.
]]>