D365FO - SSRS - The Configuration/Dsn application cannot be run in Win32 mode.

 

Recently a D365FO Tier-1 CHE SSRS instance completely stopped working. What was strange is the service could be stopped and started with no issues. But if you look at event viewer 5mins after it was started you would start to see the following error message.

 

Report Server(WMI10) : The Configuration/Dsn application cannot be run in Win32 mode.

 

In order to resolve the issue I tried the following

 1.) restoring C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\rsreportserver.config from another server

2.) updating SSRS

3.) Repair installation of SSRS 

 

However nothing seemed to work until I did the following to completely remove and start with a fresh instance of SSRS and then remap it to D365

 

1.)    completely uninstall  SSRS

2.)    install ssrs

3.)    remove the old ssrs database

4.)    create a new database using the same names within SSRS config

5.)    run J:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeploySsrsExtension.ps1 but you need to make sure you let it finish. It gives you the impression its done but  really isn’t until 10-15mins later  (D365 will not recognize this as a valid SSRS instance until this is done even though its running)

6.)     after the above completes it is letting me run the .deploy report script for reports and apply platform updates again

D365FO - Tier-1 - CHE - SSRS Wont Start - RSHostingService.exe Description: The process was terminated due to an unhandled exception. Exception Info: System.Xml.XmlException (Cloudstrike)

It would appear the CrowdStrike issue that plagued PC's and server's worldwide may cause some SSRS instances to stop being able to be started on a CHE Tier-1 for D365FO.

The following error below may be present within event viewer when trying to start the SSRS service. This issue is due to the corruption of a SSRS web.config file

Application: RSHostingService.exe 

Framework Version: v4.0.30319 

Description: The process was terminated due to an unhandled exception. 

Exception Info: System.Xml.XmlException at System.Xml.XmlTextReaderImpl.Throw(System.Exception) at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Char[], Int32, Int32) at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace() at System.Xml.XmlTextReaderImpl.ParseDocumentContent() at System.Xml.XmlReader.MoveToContent() at System.Xml.Linq.XElement.Load(System.Xml.XmlReader, System.Xml.Linq.LoadOptions) at System.Xml.Linq.XElement.Load(System.String, System.Xml.Linq.LoadOptions) at Microsoft.BIServer.Configuration.ConfigReader..ctor(System.String) at Microsoft.BIServer.BIService.ServiceConfig..ctor(System.String) at Microsoft.BIServer.BIService.BIService.SetNewConfigFilePathIfExists(System.String) at Microsoft.BIServer.BIService.BIService..ctor() at Microsoft.BIServer.BIService.Program.Main() 




Faulting application name: RSHostingService.exe, version: 15.0.1102.1084, time stamp: 0x64b6b433 

Faulting module name: KERNELBASE.dll, version: 10.0.20348.2400, time stamp: 0x784b07c7 Exception code: 0xe0434352 

Fault offset: 0x000000000003f19c 

Faulting process id: 0x2824 

Faulting application start time: 0x01dae1f335c6e225 

Faulting application path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\RSHostingService\RSHostingService.exe 

Faulting module path: C:\Windows\System32\KERNELBASE.dll 

In order to fix the issue the following needs to occur

1.) Go to C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer

2.) Rename web.config to web.config.old or web.config.bak

3.) Copy new web.config to C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer

4.) Open Services.msc

5.) Start  SQL Server Reporting Services

You can download the needed default web.config here

You may also run into the following files needing to be replaced as well

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\rssrvpolicy.config

C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\Portal\RSPortal.exe.config

You can tell if it needs to be replaced or not by simply opening the text file in note pad. If its blank its needs replaced if you can see text you are fine.