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