SQL Server Reporting Services shows DTD prohibited in XML document error

Question

I am getting the following error when running a reporting services report.

Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE 
Exception information: 
 Exception type: XmlException 
 Exception message: 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.

I select a report, enter the parameters(the parameters look messed up) and then press view report. Then at the bottom the message "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings ..." shows up.

How do I fix this?

Answer 1

Check to see if your reporting server website has the correct local path folder. You might need to do an iisreset if it is not correct.

Answer 2

I have noticed this when using SSRS 2005 and running large reports containing XML data.

It would work when running say a monthly report, but give me this error when I ran a quarterly report.

Upgrading to SQL/SSRS 2008 fixed the issue for me!