Patching SQL Server 2019 on EC2 failing

Question

The SQL Server instance on an EC2 server was pre-installed by AWS, but when attempting to patch the installation, the process fails due to an attempt to download Python and R from third-party sites, which are inaccessible. There is no need for Python or R to be installed with SQL Server, but the option to exclude them was not available during the installation. Despite attempting to skip the upgrade, the installation process hangs during the Python and R download phase.

Answer

Since you don't need Python and R installed with SQL Server, you can try disabling their installation during the SQL Server upgrade process. To do this, use the command line parameter "/SkipInstallerRunCheck" when you run the SQL Server upgrade.

To use the "/SkipInstallerRunCheck" parameter, follow these steps:

Open the Command Prompt as an Administrator.

Navigate to the directory where the SQL Server setup files are located.

Run the SQL Server setup executable file and specify the "/SkipInstallerRunCheck" parameter. For example:

setup.exe /SkipInstallerRunCheck

Follow the instructions in the SQL Server setup wizard, and when prompted for features to install, deselect the options for Python and R services.
Note that this parameter only disables the installer run check and does not actually remove any installed components. Therefore, if you have already installed Python and R services, you will need to uninstall them separately after the installation or upgrade is complete.

Also, keep in mind that disabling the installation of Python and R services may affect any applications or scripts that rely on them. Therefore, make sure to assess the impact of disabling these features before doing so.

Patching SQL Server 2019 on EC2 failing

Contenido relevante