D. Discovery > D.7.1. Database Instances > SQL SMO

SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server.

The steps below help ensure that SQL SMO is configured correctly on the MID Server.
Documentation Credit: https://msdn.microsoft.com/en-us/library/ms162189(v=sql.100).aspx

Step 1: Installation of Common Language Runtime (CLR)

As a prerequisite before installing ‘SQL SMO Library’ it is necessary to install the .NET Framework SDK which also includes the Common Language Runtime (CLR) library, a prerequisite for the SQL SMO installation.
It is available for download at https://www.microsoft.com/en-us/download/developer-tools.aspx

Step 2: Installation of SQL Server Management Object (SMO)

To support an application that uses SQL Server Management Objects (SMO), select the Client Tools SDK in SQL Server installation or to install the Client Tools SDK without installing SQL Server, install Shared Management Objects from the SQL Server 2008 R2 feature pack.
To ensure that SQL Server Management Objects is installed on a computer (ServiceNow MID Server Host), install the ‘Shared Management Objects.msi’ from the feature pack. By default, the SMO assemblies are installed in the directory C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\

For more information, contact us at info@quicknexus.com