SQL Reporting Service and SharePoint 2007 - For security reasons DTD is prohibited in this XML document

Friday, 22 May 2009 02:11 by RanjanBanerji

I had setup SQL reporting Service with SharePoint Integration and everything has been working fine.  Well, until a few days ago when I installed Project Server 2007.  I have three environments and the combination of Project Server 2007, SharePoint 2007, and SQL Reporting Service 2005 worked fine on two.  But on one of my development environments I started to get a strange error each time I would try to launch a report.  The error being:

“For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method."

After searching the web I found that the most common explanation for this error is when the server is running out of memory.  I didn’t quite think that was the problem in my case.  Why?  Well I had the same reports working in two other environments, plus I created a simple report that executed a simple query to get one row of data and that too triggered the error.  Plus the machine had plenty of memory.  What was irritating is that neither the SQL Reporting Server logs nor the SharePoint ULS logs and for that matter the Event Logs showed any error.

Based on prior SharePoint experience I figured that this error is the result of some other error that was not handled correctly and then some code tried to parse the exception thinking it was XML and blew up.  Anyway, after much head scratching and analysis of my servers I finally found the culprit.  I am not sure how this happened but in IIS the default web site that hosted the report server virtual directory the following two account groups no longer had any permissions:

 

SQLServer2005ReportingServicesWebServiceUser$COMPUTER_NAME$MSSQLSERVER

SQLServer2005ReportServerUser$COMPUTER_NAME$MSSQLSERVER

 

Once assigned read, write permissions on the default side (cascading) the error vanished and everything was back to normal.

Categories:   SQL Server | SharePoint
Actions:   E-mail | Permalink | Comments (0) | Comment RSSRSS comment feed

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading