Resolving SQL Errors During the Aeon 5.2 Server Update/Installation

Issue

Beginning with Aeon 5.2, the Aeon Server will use the Microsoft OLE DB Driver for SQL Server in place of the SQL Server Native Client due to the end of support for this component by Microsoft. As part of this change, the Aeon 5.2 server installer PowerShell scripts will now also use the SQL Server PowerShell Module during the Aeon 5.2 update/installation process. The scripts will use whichever version of the module is currently installed on the Aeon Server, if present. If the module is not yet installed on the Aeon Server, then the latest version of the module (v22.0.59 at the time of the Aeon 5.2 release) will be installed during the server installation/update process.

The most recent version of the SQL Server PowerShell Module (v22.0.59) requires that .NET Framework 4.7.2 or higher is installed on the Aeon Server. If this version of the SQL Server PowerShell Module is already present on the Aeon Server or if it is installed by the 5.2 server installer scripts, then the following error will be returned during the Aeon 5.2 update/installation process if the version of the .NET Framework installed on the server is insufficient:

Invoke-Sqlcmd : The type initializer for 'Microsoft.Data.SqlClient.InOutOfProcHelper' threw an exception.

Resolution

Users encountering this error when running the Aeon 5.2 server installer scripts should update the .NET Framework on the Aeon Server to v4.7.2 or higher, then re-attempt to perform the Aeon 5.2 server installation/update.