Hi
I have management reporter CU16 installed with GP 2018 along with SQL Server 2019 in production Environment. . Everything was running perfectly for few months till someone install an old application that require SQL 2008 on the same server.
Since then the MR Process service keep swinging up and down.
We did uninstall the old application that we thought it might behind that issue but no impact.
Even I uninstalled MR and reinstall it and still the process service start and shutdown by itself.
Also I did a repair for SQL Server 2019 as according to MS KB it could caused by Microsoft System CLR still failing.
I do have a test Environment which is mirroring the production and it has everything working fine on it.
Is there anyway I can compare the two servers to see what make it work fine in Test but not in Prod
Really appreciated.