One of the New Features introduced in 2022R4 is its support for Azure Elastic Pool Database. This has necessitated the installation and configuration of Powershell 7.2 during the Console configuration process. 

This change means that all the Components should be upgraded at the same time if you are applying 2022R4 to a system with an earlier Release. 

Fresh installation 

If you are configuring a new System, then you will notice a new field, “pwsh(.exe) executable fullpath” which must be filled-in 

The text in this dialog-box is 

Download the 64-bit version msi downloaded  from https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.2 

Run a DOS cmd shell with “Run as Administrator” and then set up the PowerShell for SQL:  

pwsh -Command "Install-Module -Name SqlServer -Scope AllUsers -force" 

After installing and configuring Powershell 7.2, update the Console with C:\Program Files\PowerShell\7\pwsh.exe 

Once this has been done, continue with the install as normal. 

Upgrading to 2022R4 

If you are applying 2022R4 to an existing System, you will see “The console has detected that the dictionary of your component has changed” messages in the Data Application tab. 

On attempting to Configure Application, you will be asked to Configure Database first 

On clicking Configure Database, you will be prompted to set up a new field, “pwsh(.exe) executable fullpath” 

The text in this dialog-box is 

Download the 64-bit version msi downloaded  from https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.2 

Run a DOS cmd shell with “Run as Administrator” and then set up the PowerShell for SQL:  

pwsh -Command "Install-Module -Name SqlServer -Scope AllUsers -force" 

After installing and configuring Powershell 7.2, update the Console with C:\Program Files\PowerShell\7\pwsh.exe 

Now, click the Save button to save the solutions.xml configuration 

You should now be able to Configure Application 

At this point, you are prompted to confirm that you want to “Execute update scripts” 

After clicking on “Execute update scripts” button, the process runs and completes with 

After this step, you should be able to proceed with the Configure Application process.