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 (SMO).

JAMS attempts to search for SQL Server SMO versions from the latest version (version 13) down to the oldest supported version (version 9). Once JAMS finds an SMO version, it will use that version. 

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. Users should read the Software and Hardware Prerequisites article that corresponds to their version of JAMS in order to understand which SQL versions are supported by their JAMS version.

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

To find the appropriate version of Shared Management Objects, search the internet for "Shared Management Objects XXXX Download" where XXXX is the version of SQL that is described in the exception. Download and install SMO on the machine where the error occurs, then restart the JAMS client and attempt the operation again.

NOTE: If you already have SQL Shared Management Objects installed users can force JAMS to utilize a specific version of SQL Server SMO by adding a parameter called JAMSSQLVersion on a given Job.

Possible values for the JAMSSQLVersion parameter are:

  • 2005
  • 2008
  • 2012
  • 2014
  • 2016
Have more questions? Submit a request