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

Seuli Das Majumder 101 Reputation points
2020-10-26T16:08:13.023+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,091 Reputation points Microsoft Vendor
    2020-10-27T07:23:31.817+00:00

    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.