SQL Server Discovery throwing below error: Unable to load assembly Microsoft.SqlServer.Smo. The SMO library must be installed on the MID Server hostHRESULT: [-2146233087] - Support and Troubleshooting

SQL Server Discovery throwing below error: Unable to load assembly Microsoft.SqlServer.Smo. The SMO library must be installed on the MID Server hostHRESULT: [-2146233087] Issue When trying to discover a SQL server, we may see the below warning in the discovery logs

Unable to load assembly Microsoft.SqlServer.Smo. The SMO library must be installed on the MID Server hostHRESULT: [-2146233087]

Cause This is appearing because the installation of the Microsoft SQL Server management library (SMO) on the Mid-Server machine is missing

Resolution Recommendation: ===============

From the MID Server host: ======================= 1. Install .Net 3.5 and 4 from Microsoft

2. Install the latest version of the Microsoft SQL Server management library (SMO). Note: The SMO requires the Common Language Runtime (CLR) library to be installed first. Both libraries can be downloaded from the Microsoft website.

Please work with your windows team to get assistance on the installation, also below are some articles that help us more on how/where we can get the files

https://community.servicenow.com/community?id=community_question&sys_id=64c5992fdb31a380f21f5583ca9619c7 https://netlibsecurity.com/kb/kb-240112-installing-sql-server-shared-management-objects-sql-smo/

3. Install PowerShell v2.0 and above.

From the Microsoft SQL Server Host: =============================== 1. Install the Remote Registry Service on target computers running Microsoft SQL Server.