Could not load file or assembly ‘Microsoft.SqlServer.smo’,… The system cannot find the file specified.
Be sure to install the x86 version of SQL Server SMO.
The program requires SQL Server Management Objects (SMO) in order to complete the operation and that module is not loaded on your system.
Microsoft SQL Server Management Objects The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services.
The latest version of SQL SMO is in the SQL Server 2014 Feature Pack.
https://www.microsoft.com/en-us/download/details.aspx?id=42295
(If you are using an older version of SQL Server, you can use the version that comes with that version. It’s always in the feature pack for the version. But the above version for SQL Server 2014 will work for all versions of SQL Server).
Note: Microsoft SQL Server 2008 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are part of the feature pack or can be downloaded from the same location.
Be sure to install the x86 version of SQL Server SMO.