Resolve Microsoft SQL Server Load Errors


Users may encounter the error Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=X.x.x.x

If this error is encountered it is an indication that the machine running the JAMS Client is missing the SQL Shared Management Objects.

This may be seen when trying to create a Job utilizing the SQLStoredProc, SSISDirect or SSRS Execution Method or additionally if trying to view the External Tab.

It is advised that regardless of the version number of the error, you install SMO based on the version of SQL being utilized.

The following version numbers corresponds to the version of SQL:

  • SQL 2016 - 13
  • SQL 2014 - 12
  • SQL 2012 - 11
  • SQL 2008 - 10
  • SQL 2005 - 9
Have more questions? Submit a request