Knowledge Base

Search Knowledge Base

KB #240112: Installing SQL Server Shared Management Objects (SQL-SMO)

Type:

Information

Summary:

The newest version of Column Encryption Manager requires SQL-SMO. Instructions for installing are shown below. Please note different downloads if using SQL 2012 SP2.

Additional Information:

To download the installers for SQL Server Shared Management Objects (SQL-SMO or SQLSMO) use the following links:

Download installers directly from Microsoft

Recommendation: Right-click on links and Save-As to Desktop.

  1. CLR Types for Microsoft SQL Server: all versions except SQL Server 2012 SP2
  2. CLR Types for Microsoft SQL Server 2012 SP2
  3. SQL Server Shared Management Objects for Microsoft SQL Server: all versions except SQL Server 2012 SP2
  4. SQL Server Shared Management Objects for Microsoft SQL Server 2012 SP2

Alternatively go directly to the Microsoft download page. Important: Do not click the red download button. Instead expand Install Instructions and look for both items listed above.

Installation Instructions

  1. Download the appropriate installers.
  2. Install CLR Types for Microsoft SQL Server
  3. Install SQL Server Shared Management Objects

Reboot is usually not required.Note that even though these downloads mention SQL Server 2014, they support SQL 2005 and later.

Top