Unable to Load DLL 'SqlServerSpatial140.dll'

Affected Software/Reports/DLL(s):  Professional EDP

Affected Software Version: Professional

Symptoms: When processing data targeting the DT_GEOGRAPHY.GEOGRAPHY field, the following error occurs:

Unable to load DLL 'SqlServerSpatial140.dll': The specified module could not be found.

Cause/Details: The problem can occur because either the appropriate SQL Clr Data Type is not installed or is the wrong version. In older builds of EQuIS, this can occur when EQuIS Professional is installed via an .msi file rather than via the .exe as instructed here.

Resolution/Workaround: Download and install the Microsoft SQL Server 2014 Feature Pack item. This fix can be applied to workstations where Microsoft SQL Server and Microsoft SQL Server Management Studio have not been installed.

Note: The hotfix only needs to be applied when the above noted error is encountered.

Download and Install 2017 SQLSysClrTypes.msi

1.Go to https://www.microsoft.com/en-us/download/details.aspx?id=55992

2.Click the  Download  button. At the Choose the download you want prompt, check ”\x64\SQLSysClrTypes.msi” (in the middle of list). Click Next to download.

3.Save the install package to a known location on the computer.

4.After the download is complete, make sure to UNBLOCK the file using the instructions in this help article. Execute the file to install the SQL Server System CLR Types.

5.Follow instructions for the Microsoft Install Wizard.

After completing these steps, reopen EQuIS Professional and launch Professional EDP. The error should be resolved.