2022R4 introduces support for Azure Elastic Pool Database - installation requires PowerShell 7.2

2 minute read time.

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 

pwsh[.exe] is the executable file name of Microsoft PowerShell v7.2 +, the cross-platform edition of PowerShell built on .NET Core / .NET 5+. 

Ex: C:\Program Files\PowerShell\7\pwsh.exe  -  Linux:  /usr/bin/pwsh 

Do not use powershell.exe, which is the executable name of the legacy Windows PowerShell edition (v5.1-), built on the Windows-only .NET Framework (v4.8-)  

To install MS PowerShell Version 7, please go to https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell?view=powershell-7.2 

If your database is MS SQLServer, after installation, please open a command line panel and launch the command: pwsh -Command "Install-Module -Name SqlServer -Scope AllUsers -force" 

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 

pwsh[.exe] is the executable file name of Microsoft PowerShell v7.2 +, the cross-platform edition of PowerShell built on .NET Core / .NET 5+.

Ex: C:\Program Files\PowerShell\7\pwsh.exe  -  Linux:  /usr/bin/pwsh

Do not use powershell.exe, which is the executable name of the legacy Windows PowerShell edition (v5.1-), built on the Windows-only .NET Framework (v4.8-)                       

To install MS PowerShell Version 7, please go to https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell?view=powershell-7.2

If your database is MS SQLServer, after installation, please open a command line panel and launch the command: pwsh -Command "Install-Module -Name SqlServer -Scope AllUsers -force"

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. 

Parents Comment Children
No Data