Updating Microsoft SQL Server Express

To be able to update NoSpamProxy to version 15.1, the corresponding instances of Microsoft SQL Server Express must have at least version 2022. Proceed as follows when updating:

  1. Execute the following PowerShell script to find out in which language your SQL Server Express is installed:

    2. sqlcmd -E -d master -S localhost\SQLEXPRESS -q "SELECT CASE SERVERPROPERTY('LCID') WHEN 1033 THEN 'English' WHEN 1031 THEN 'German' ELSE 'Other' END AS Language"

    NOTE: Always run this script with the user account with which you have installed the NoSpamProxy roles on the respective system.

  2. Depending on the output of the script, download the English or German installation programme for SQL Server 2022 Express.
  3. Stop all NoSpamProxy services on the affected system.
  4. Run the installation programme and select Download media.

  5. Select the language of the installation programme and the desired package and select the download directory.

    NOTE: Make sure that there is sufficient storage space available on the target path.

  6. Click Download.
  7. Carry out the update by following the instructions of the installation wizard.

    NOTE: Make sure that you update the instance that is used by the NoSpamProxy roles. To check this, go to Configuration > NoSpamProxy components in the NoSpamProxy Command Center.

  8. Once the SQL Server Express update is complete, update the relevant roles or the entire instance (for single-machine installations).