Install SQL Server 2014 Shared Management Objects on SQL Server 2017, or 2019

If you installed SQL Server 2017, or 2019, install also the SQL Server 2014 Shared Management Objects (SMO). If you installed SQL Server 2022, do not install SQL Server 2014 Shared Management Objects (SMO).

Do not perform this step if you installed SQL Server 2022.

Shared Management Objects must be installed on the SQL Server hosting the reporting database server role, either on a local SQL Server or a Database Management Server (DBMS) in remote SQL Servers environment. This includes one of the following servers by deployment level:

  • L1: Consolidated Server

  • L2: Data Center Server

  • L3: Database Server or DBMS

  • L4/L5: Framework Database & Reporting Server

  • L6: Reporting Server

Procedure 

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

  2. Download the following SQL Server 2014 SP2 SMO msi files:

    1. ENU\x64\SQLSysClrTypes.msi

    2. ENU\x64\SharedManagementObjects.msi

    3. ENU\x86\SQLSysClrTypes.msi

    4. ENU\x86\SharedManagementObjects.msi

  3. Install the msi files on each server with SQL Server 2017, or 2019 in the previous specified order.