Resolve Microsoft SQL Server Load Errors

Follow

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.

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

 

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

Comments