This is a notification for product news or an alert. If you have a question, please start a new discussion

ALERT: SQL Server PowerShell module

Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only. 

PowerShell 7.2+ is a prerequisite for Sage X3 and the SQL Server module for PowerShell. SQL Server module version 22.0.59 has been released recently and will be downloaded by default if you install the SQL Server module without any version specified. 

SQL Server module version 22.x will not work with the Sage X3 Management Console because of changes in how SQL Server connects to the database.

Please use SQL Server version 21.1.18256 (last production version before 22. x) when downloading the SQL Server module, using the following command in PowerShell as an Administrator: 

Install-Module -Name SqlServer -RequiredVersion 21.1.18256 -Scope AllUsers

Instead of 

Install-Module -Name SqlServer-Scope AllUsers

If you have already installed SQL Server 22. x, please uninstall and reinstall SQL Server 21.1.18256 using the following sequence of commands in PowerShell as an Administrator: 

Uninstall-module SQLServer -Force -Verbose 

Install-Module -Name SqlServer -RequiredVersion 21.1.18256 -Scope AllUsers 

You can also use the Install-Module command to overwrite a previous version:

Install-Module -Name SQLServer -AllowClobber 

You can use the following command to verify which version of the SQL Server module you are running: 

Get-Module SqlServer -ListAvailable

NOTE: Please restart the Sage X3 Management Console if it was running during the uninstallation and reinstallation of the SQL Server module.