IIS 6 MMC problem with ReportServer and ASP.NET configuration

IIS 6 MMC problem with ReportServer and ASP.NET configuration

• Paul Lambert

  Report Service on SqlServer 2005 Express doesn't support XML datasources!!!

  http://msdn2.microsoft.com/en-us/library/ms365166.aspx

  
  

• Marino Fourotunis

  Thanks a billion phillippe... it worked for me.

  one more help please. here is an another error i faced while trying the access the url

  http:\\localhost\reportserver_1

  • The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Help

  Thanks in Advance.

  
  
  

• Russell Maidment

  I just did one of your suggested fixes as far as the IIS6 Internal error is concerned and let me tell you ... YOU ARE THE MAN! Are you by any chance ... Bill Gates (just kidding. thanks)

  I sure would like to know Why it happened though...

  (remove xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0 to fix problem)

  
  

• bk pradeep

  Capistrc wrote:

  Are you by any chance ... Bill Gates (just kidding. thanks)

  I do not wish I was, It would be more difficult to find what to do with the money that it is to work with Microsoft products :-)

  I wonder if anyone at Microsoft can look into this xml xonfig issue, it is a bad trap.

  Philippe

  
  

• JinGuoLi

  What is XML in this report

  If the report extension is xml, change the extension to rdl

  Philippe

  
  

• X5-Eric

  I'm having the same problems, but I don't have have the xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" in either web.config file.

  Any ideas

  
  

• Chris Hewitt

  Dear Philippe, you help many of us a lot ( I am serious),

  May be you know something about this error:

  The reports based on XML is perfectly displayed in development Environment.

  But than uploaded to Server, the following occurs:

  • An error has occurred during report processing.
  • An attempt has been made to use a data extension 'XML' that is not registered for this report server.

  Thank you very much.

  
  

• Steve Wooster

  Hi,
  Unfortunately, I have no precise answer to that one. May be someone else in this forum would know
  I personally use a Windows account to run both Windows service and the execution account. This Windows account is set to never expire.
  For the Report Web Service I use the default NT Authority\NetworkService
  For the Database connection I use the Service credentials.
  Of course, I keep a backup of the encryption key. If I restore the report server database I have to restore the encryption key.
  I do not use SSL and I am not familiar with it.
  Philippe
  
  

• Billy Hui

  Here is the complete reportserver log info.

  Please let me know if this is the correct forum. To me, it is a bug. Not sure if it relates to Reporting services install, ASP net or what. The fact is that this bug can be reporoduced with a couple of clicks. I notticed it is also disabling other ASP.Net apps, even if they are in a different Application pool. The bug will reproduce regardless if you have ASP 1.2 and 2.0 or only 2.0, the bug is a ASP.NET2.0 bug.

  Thanks,

  Philippe

  ------------------------

  <Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>US Mountain Standard Time</TimeZone>
  <Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServerWebApp__02_15_2006_08_24_07.log</Path>
  <SystemName>SMDEV</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
  </Header>
  w3wp!ui!1!2/15/2006-08:24:07:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
  w3wp!ui!1!2/15/2006-08:24:07:: e ERROR: HTTP status code --> 500
  -------Details--------
  Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

  at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

  at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

  at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

  at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

  at System.EventHandler.Invoke(Object sender, EventArgs e)

  at System.Web.UI.Control.OnInit(EventArgs e)

  at System.Web.UI.Page.OnInit(EventArgs e)

  at System.Web.UI.Control.InitRecursive(Control namingContainer)

  at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  w3wp!ui!1!2/15/2006-08:25:12:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
  at System.Threading.Thread.AbortInternal()
  at System.Threading.Thread.Abort(Object stateInfo)
  at System.Web.HttpResponse.End()
  at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
  at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
  at System.Threading.Thread.Abort(Object stateInfo)
  at System.Web.HttpResponse.End()
  at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
  at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
  

  
  

• asimelahi

  Hi,

  I've created a report which uses XML Data source. It gets the data from a web service which is returning a dataset. I tried to Preview the report using Visual Studio IDE which worked fine. Then i deployed it. The problem started when i tried to view the report using web browser and reporting server. It keeps giving me following error message:

  An error has occurred during report processing. (rsProcessingAborted)

  • An attempt has been made to use a data extension 'XML' that is not registered for this report server. (rsDataExtensionNotFound)

  I am using 2005 SQL Express and reporting service. Please help me out in this problem as i am stuck in it.

   

  Thanks,
  Moby.

  
  

• sathupadikesavan

  No, Philippe, there is an option to use XML as data source for your reports in SQL 2005.

  So, that's what I am using.

  In designer I can see report based on XML, but cannot process it on the Reporting Server. Getting error:

  • An error has occurred during report processing.
    • An attempt has been made to use a data extension 'XML' that is not registered for this report server.

    • rsreportserver.config

    • <Data>

      <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

      <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>

      </Data>

  
  

• RayJohnson

  Hi, maybe we have the same or a similar problem. Take a look at my thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=267071&SiteID=1

  Regards, Jonas

  
  
  

• patria

  Thank you very much Phillipe.

  
  

• Carl Mercier

  Hello,

  We have found a workaround to this bug.

  Just remove this

  xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"

  From the WEB.config file in both ReportServer and ReportManager folders

  Philippe

  
  
• IIS 6 MMC problem with ReportServer and ASP.NET configuration