need Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be in assembly

Question

I am having missing DLL error while running an EXE. I am looking for Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be in my assembly.
While searching I found two msi are suggested to install for it. 'SQLSysClrTypes.msi' and 'SharedManagementObjects.msi'. The first one i got . but for second one from sql server 2017 it is replaced with Microsoft.SqlServer.SqlManagementObjects.

I want Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be installed and in my assembly. Please suggest how to get it to be done and with which MSI?

Answer 1

Hi @Seuli Das Majumder ,

Did you apply the latest CU for SQL server 2017? Did you using the latest SSMS 18.7?

The Microsoft.SqlSever.SqlClrProvider.dll can be installed by running the following MSIs:

SQLSysClrTypes.msi
Microsoft.SqlServer.SqlManagementObjects.msi

You can get them from below links.

Microsoft® SQL Server® 2017 Feature Pack
Installing SMO

Please check if this similar thread Could not load file or assembly microsoft.sqlserver.sqlclrprovider 13.100.0.0. could help you.

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it.