What are the correct procedures to install the Microsoft SQL Server Management (SMO) library on a MID server?

Tom Rausch
Tera Guru

ServiceNow documentation apparently states that we must install the Microsoft SQL Server Management (SMO) library on the MID server in order to Discover MSSQL servers (https://docs.servicenow.com/bundle/london-it-operations-management/page/product/discovery/reference/mssql-data-collected-pattern.html, https://docs.servicenow.com/bundle/geneva-it-operations-management/page/product/discovery/reference/r_MicrosoftSQLServers.html).

We installed the SMO on one of our MID servers as part of a larger VisualStudio installation (Installed SMO.png). Unfortunately, when we attempt to run a Discovery against a machine that has a MSSQL server, we obtain the error "Unable to load assembly Microsoft.SqlServer.Smo. The SMO library must be installed on the MID Server host" (Discovery - SMO Error.png) .

What is the correct way to install the SMO on the MID server?