I came across a strange issue when trying to upgrade CRM deployment to Microsoft SQL Server 2017. Important note: It is not listed as a supported version https://technet.microsoft.com/en-us/library/hh699754.aspx And here is probably why. Everything went smooth until I tried to reinstall Dynamics 365 Reporting Extensions via SetupSrsDataConnector.exe. Since SQL Server 2017 we have a standalone installer of Reporting Services. It configures SSRS instance differently but I could find why Reporting Extensions wizard fails to locate it. I had even tried to use XML config to pass the instance parameters to the SetupSrsDataConnector.exe directly. After successful installation SrsDataConnector wizard was unable to locate my SSRS instance. Without correct setup of SrsDataConnector environment checks will fail when you try to provision a new organization or import an existing one. You can set a flag in registry to ignore the errors if you are ok to proceed without reporting services. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM DWORD IgnoreChecks = 1 It will let you create an org but I wasn’t able to import or upgrade existing ones due to errors during the process. Only solution was using SQL Server 2016 end installing Reporting Services using the classic server installer.
Leave a Comment
Your email address will not be published. Required fields are marked *