Skip to content
logo Knowledgebase

Error: "Class not registered" opening the Database Utility

Created on  | Last modified on 

Summary

Required SQL 2016 components for Sage Fixed Assets Premier 2020.1 and higher.

Cause

The server doesn't have the required Microsoft SQL 2016 components installed. Alternatively, the server has the wrong version of those components on the SFA Premier server.

Missing components can cause errors such as:

  • "Class not registered" on opening the Database Utility
  • Failed to load SMOEXT.dll Exiting the utility
  • ExecuteNonQuery failed for database. Could not load file or assembly "Microsoft.SQLServer.BatchParser" version

SQL requires the components noted below, regardless of the SQL version installed on the machine.

Resolution

On the server where you installed Sage Fixed Assets Premier server 2020.1 or higher, check Program and Features. Start, Control Panel, Program and Features. Look for the version 13.0.1601.5 or the following components:

 

Note: The names of the components below look the same, but the objects are for 32-bit and 64-bit machines. You can only see these on the download site.

For all systems:

  • Microsoft SQL Server System CLR Types 13.0.1601.5
  • Microsoft SQL Server System CLR Types 13.0.1601.5
  • Microsoft SQL Server 2016 Management Objects 13.0.1601.5
  • Microsoft SQL Server 2016 Management Objects (x64) 13.0.1601.5

To Download these components: Go to: https://www.microsoft.com/en-us/download/details.aspx?id=103444, Click Download, Select on the following components:

  • SQLSysClrTypes.msi 2.6 MB
  • SQLSysClrTypes.msi 3.6 MB
  • SharedManagementObjects.msi 6.5 MB
  • SharedManagementObjects.msi 5.5 MB

 

Need more help?

Chat now