Tuesday, December 8, 2020

Install D365 together with the update

 This should be done using the config file

1. download the update extract to a folder

C:\Update\Version-Server-<KB>-ENU-amd64.exe /extract:C:\Update\Version

create a config file stating the update ; save in C:\Update\Configs as Server.txt

<CRMSetup>

 <Server>

 <Patch update="true">C:\Update\Version\Server_<KB>_amd64_1033.msp</Patch>

 </Server>

 </CRMSetup>


Now run the installer

~~\SetupServer.exe /config C:\Update\Configs\Server.txt


SSRS in blank while setting up D365 Srs Reporting extention

 While setting up srs connector for Dynamics 365 (for SQL 2017) the SSRS instance was blank.

check all things

1. installing this component in right server, means in the server where report server was installed : it is correct

2. account is correct

finally found below article https://stackoverflow.com/questions/50265735/crm-reporting-extension-ssrs-instance-is-blank , helped me

1) Download nssm util - https://nssm.cc/download


2) Unzip nssm.exe and copy to windir (c:\windows)


3) Run cmd as administrator and then command : nssm install ReportServer$SSRS c:\windows\notepad.exe


4) Start service ReportServer$SSRS ( net start ReportServer$SSRS )


5) Open registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SSRS\Setup and add REG_SZ attribute with name Version and value '14.0.600.1572' (SSRS version)


6) Install crm connector (SetupSrsDataConnector.exe)


7) Install latest patch for crm convertor (greather then 0.3) - https://support.microsoft.com/en-us/help/3142345/microsoft-dynamics-365-onpremise-cumulative-updates (CRM9.0-Srs-KBXXXXXX-ENU-Amd64.exe)


8) Restart server


9) Stop service ReportServer$SSRS ( net stop ReportServer$SSRS )


10) Remove dummy service : nssm remove ReportServer$SSRS confirm


11) Optional - delete nssm.exe from windows directory