Upgrade a deployment
You can upgrade certain deployments to newer versions without having to first set up new machines or sites. This is called an in-place upgrade. To learn which Citrix Virtual Apps and Desktops versions you can upgrade, see the Citrix Upgrade Guide.
To start an upgrade, you run the installer from the new version to upgrade previously installed core components, VDAs, and certain other components. Then you upgrade the databases and the site.
You can upgrade any component that can be installed with the full-product installer (and the standalone VDA installers), if there is a newer version provided. For other components that are not installed with the full-product installer (such as Citrix Provisioning and Profile Management), see that component’s documentation for guidance. For host upgrades, see the appropriate documentation.
Review all the information in this article before beginning an upgrade.
The following diagram shows the steps the upgrade sequence. Upgrade procedure contains details of each step in the diagram.
Most of the main product components can be upgraded by running the product installer on the machine containing the component.
If one machine contains more than one component (for example, Studio and License Server), all components on that machine are upgraded, if the product media contains newer versions of their software.
To use the installers:
- To run the full product installer’s graphical interface, log on to the machine and then insert the media or mount the ISO drive for the new release. Double-click AutoSelect.
- To use the command-line interface, issue the appropriate command. See Install using the command line.
Step 1: Prepare
Before you begin an upgrade, make sure you’re ready. Read and complete any necessary tasks:
- Upgrade VDAs to 1912 or later
- Mixed environment considerations
- Earlier operating systems
- Preliminary site tests
- SQL Server version check
Step 2: Upgrade License Server
If the installation has a new version of the Citrix License Server software, upgrade this component first before any other components.
If you have not yet determined whether your License Server is compatible with the new version, it is essential that you run the installer on the License Server before upgrading any other core components.
Step 3: Upgrade StoreFront
If the installation media contains a new version of the StoreFront software, run the installer on the machine containing the StoreFront server.
- In the graphical interface, choose Citrix StoreFront from the Extend deployment section.
- From the command line, run
CitrixStoreFront-x64.exe, which is available in the Citrix Virtual Apps and Desktops installation media’s
Step 4: Upgrade Director
If the installation media contains a new version of the Director software, run the installer on the machine containing Director.
Step 5: Upgrade Citrix Provisioning
The Citrix Provisioning installation media is available separately from the Citrix Virtual Apps and Desktops installation media. To learn how to install and upgrade Citrix Provisioning server and target device software, see the Citrix Provisioning product documentation.
Step 6: Upgrade half of Delivery Controllers
For example, if your site has four Controllers, run the installer on two of them.
Leaving half of the Controllers active allows users to access the site. VDAs can register with the remaining Controllers. There might be times when the site has reduced capacity because fewer Controllers are available. The upgrade causes only a brief interruption in establishing new client connections during the final database upgrade steps. The upgraded Controllers cannot process requests until the entire site is upgraded.
If your site has only one Controller, it is inoperable during the upgrade.
Preliminary site tests run on the first Controller, before the actual upgrade starts. For details, see Preliminary site tests.
Step 7: Upgrade Studio
If you haven’t already upgraded Studio (because it was on the same machine as another component), run the installer on the machine containing Studio.
Step 8: Restart Studio
Restart the upgraded Studio. The upgrade process automatically resumes.
Step 9: Upgrade database and site
Check Preparation for the permissions required to update the schema of the SQL Server databases.
- If you have sufficient permission to update the SQL Server database schema, you can initiate an automatic database upgrade. Continue with Upgrade the database and site automatically.
- If you do not have sufficient database permissions, you can initiate a manual upgrade that uses scripts, and proceed with the help of your database administrator (someone who has the required permissions). For a manual upgrade, the Studio user generates the scripts and then runs the scripts that enable and disable services. The database administrator runs other scripts that update the database schema, using either the SQLCMD utility or the SQL Server Management Studio in SQLCMD mode. Continue with Upgrade the database and site manually.
- If you have a multi-zone deployment and want to upgrade the database and site automatically, Citrix recommends that the dbschema upgrade should be performed in the same zone that hosts the SQL server databases of the site. Otherwise, upgrading the database and site automatically might fail.
Citrix strongly recommends that you back up the database before upgrading. See CTX135207. During a database upgrade, product services are disabled. During that time, Controllers cannot broker new connections for the site, so plan carefully.
Upgrade the database and site automatically
- Start the newly upgraded Studio.
- Indicate that you want to start the site upgrade automatically and confirm that you are ready.
The database and site upgrade proceeds.
Upgrade the database and site manually
- Start the newly upgraded Studio.
- Indicate that you want to upgrade the site manually. The wizard checks for License Server compatibility and requests confirmation.
Confirm that you have backed up the database.
The wizard generates and displays the scripts and a checklist of upgrade steps. If a database’s schema has not changed since the product version being upgraded, that script is not generated. For example, if the logging database schema does not change, the
UpgradeLoggingDatabase.sqlscript is not generated.
Run the following scripts in the order shown.
DisableServices.ps1: The Studio user runs this PowerShell script on a Controller to disable product services.
UpgradeSiteDatabase.sql: The database administrator runs this SQL script on the server containing the Site database
UpgradeMonitorDatabase.sql: The database administrator runs this SQL script on the server containing the Monitor database.
UpgradeLoggingDatabase.sql: The database administrator runs this SQL script on the server containing the Configuration Logging database. Run this script only if this database changes (for example, after applying a hotfix).
EnableServices.ps1: The Studio user runs this PowerShell script on a Controller to enable product services.
After the database upgrade completes and product services are enabled, Studio automatically tests the environment and configuration, and then generates an HTML report. If problems are identified, you can restore the database backup. After resolving issues, you can upgrade the database again.
- After completing the checklist tasks, click Finish upgrade.
Step 10: Upgrade remaining Delivery Controllers
From the newly upgraded Studio, select Citrix Studio site-name in the navigation pane. On the Common Tasks tab, select Upgrade remaining Delivery Controllers.
After completing the upgrade and confirming completion, close and then reopen Studio. Studio might prompt for an extra site upgrade to register the Controller’s services to the site, or to create a zone ID if it does not exist.
Step 11: Upgrade VDAs
If you’re upgrading a VDA to version 1912 or later, see Upgrade VDAs to 1912 or later.
Run the product installer on machines containing VDAs.
If you used Machine Creation Services and a master image to create machines, go to your host and upgrade the VDA on the master image. You can use any of the available VDA installers.
- For graphic interface guidance, see Install VDAs.
- For command line guidance, see Install using the command line.
If you used Citrix Provisioning to create machines, see the Citrix Provisioning product documentation for guidance about upgrading.
Watch this video to learn more:
Step 12: Update machine catalogs and Delivery Groups
- Update catalogs that use machines with upgraded VDAs.
- Upgrade catalogs that use machines with upgraded VDAs.
- Upgrade Delivery Groups that use machines with upgraded VDAs.
Step 13: After the upgrade
After completing an upgrade, you can test the newly upgraded site. From Studio, select Citrix Studio site-name in the navigation pane. On the Common Tasks tab, select Test Site. These tests run automatically after you upgrade the database, but you can run them again at any time.
The tests might fail for a Controller on Windows Server 2016 when a local Microsoft SQL Server Express is used for the site database, if the SQL Server Browser Service is not started. To avoid this:
- Enable the SQL Server Browser Service (if necessary) and then start it.
- Restart the SQL Server (SQLEXPRESS) service.
Upgrade other components in your deployment. For guidance, see the following product documentation:
- Citrix App Layering
- HDX RealTime Optimization Pack
- Profile Management
- Citrix Provisioning
- Session Recording
- Workspace Environment Management
If you need to replace the Microsoft SQL Server Express LocalDB software with a later version, see Replace SQL Server Express LocalDB.
When you update your deployment to a new CU, several database schemas can be upgraded. The following table lists which database schemas are upgraded in the process:
Definition of terms:
- Site: Site Datastore. Dbschema update is made to the Site Datastore.
- Monitor: Monitor Datastore. Dbschema update is made to the Monitor Datastore.
- Config: Configuration table. Desktop Studio version, Licensing information, or both are updated in the Configuration table.
- Logging: Logging Datastore. Dbschema update is made to the Logging Datastore.
Upgrade VDAs to 1912 or later
If the Personal vDisk (PvD) component was ever installed on a VDA, that VDA cannot be upgraded to version 1912 LTSR or later. To use the new VDA, you must uninstall the current VDA and then install the new VDA.
This instruction applies even if you never used PvD.
Here’s how the PvD component might have been installed in earlier versions:
- In the VDA installer’s graphical interface, PvD was an option on the Additional Components page. The 7.15 LTSR and earlier 7.x releases enabled this option by default. So, if you accepted the defaults (or explicitly enabled the option in any release), PvD was installed.
- On the command line, the
/baseimageoption installed PvD. If you specified this option, or used a script that contained this option, PvD was installed.
If you don’t know whether your VDA has PvD installed, run the installer for the new VDA (1912 LTSR or later) on the machine or image.
- If PvD is installed, a message appears, indicating there is an incompatible component.
- From the graphical interface, click Cancel on the page containing the message, and then confirm that you want to close the installer.
- From the CLI, the command simply fails with the displayed message.
- If PvD is not installed, the upgrade proceeds.
What to do
If the VDA does not have PvD installed, follow the usual upgrade procedure.
If the VDA has PvD installed:
- Uninstall the current VDA. For details, see Remove components.
- Install the new VDA.
If you want to continue using PvD on your Windows 7 or Windows 10 (1607 and earlier, without updates) machines, VDA 7.15 LTSR is the latest supported version.
The following limitations apply to upgrades:
Selective component install: If you install or upgrade any components to the new version but choose not to upgrade other components (on different machines) that require upgrade, Studio reminds you. For example, let’s say an upgrade includes new versions of the Controller and Studio. You upgrade the Controller but you do not run the installer on the machine where Studio is installed. Studio will not let you continue to manage the site until you upgrade Studio.
You do not have to upgrade VDAs, but Citrix recommends upgrading all VDAs to enable you to use all available features.
- Early Release or Technology Preview versions: You cannot upgrade from an Early Release, Technology Preview, or preview version.
Components on earlier operating systems: You cannot install current VDAs on operating systems that are no longer supported by Microsoft or Citrix. For more information, see Earlier operating systems.
Mixed environments/sites: If you must continue to run earlier version sites and current version sites, see Mixed environment considerations.
- Product selection: When you upgrade from an earlier version, you do not choose or specify the product (Citrix Virtual Apps or Citrix Virtual Apps and Desktops) that was set during the installation.
Mixed environment considerations
When you upgrade, Citrix recommends that you upgrade all components and VDAs so that you can access all the new and enhanced features in your edition and version.
For example, although you can use current VDAs in deployments containing earlier Controller versions, new features in the current release might not be available. VDA registration issues can also occur when using non-current versions.
In some environments, you might not be able to upgrade all VDAs to the most current version. In that case, when you create a machine catalog, you can specify the VDA version installed on the machines. (This is called the functional level.) By default, this setting specifies the minimum recommended VDA version. The default value is sufficient for most deployments. Consider changing the setting to an earlier version only if the catalog contains VDAs earlier than the default. Mixing VDA versions in a machine catalog is not recommended.
If a catalog is created with the default minimum VDA version setting, and one or more machines has a VDA earlier than the default version, those machines cannot register with the Controller, and will not work.
For more information, see VDA versions and functional levels.
Multiple sites with different versions
When your environment contains sites with different product versions (for example, a XenDesktop 7.18 site and a Citrix Virtual Apps and Desktops 1909 site), Citrix recommends using StoreFront to aggregate applications and desktops from different product versions. For details, see the StoreFront documentation.
In a mixed environment, continue using the Studio and Director versions for each release, but ensure that different versions are installed on separate machines.
Earlier operating systems
Let’s say you installed an earlier version of a component on a machine that was running a supported operating system (OS) version. Now, you want to use a newer component version, but that OS is no longer supported for the current version of the component.
For example, assume that you installed a server VDA on a Windows Server 2008 R2 machine. Now you want to upgrade that VDA to the current release, but Windows Server 2008 R2 is not supported in the current release you’re upgrading to.
If you try to install or upgrade a component on an operating system that is no longer allowed, an error message displays, such as “Cannot be installed on this operating system”.
These considerations apply to upgrading Current Release and Long Term Service Release versions. (It does not affect applying CUs to an LTSR version.)
Follow the links to learn which OSs are supported:
For LTSRs, select your LTSR version from the main Citrix Virtual Apps and Desktops product documentation page.
- System requirements.
- Components lists in articles in the What’s new category.
For CRs (Current Releases):
- Delivery Controller, Studio, Director, VDAs, Universal Print Server
- Federated Authentication Service
- For StoreFront, Self-Service Password Reset, and Session Recording, see the system requirements article for the current release.
Invalid operating systems
The following table lists the earlier operating systems that are not valid for installing/upgrading components in the current release. It indicates the latest valid component version supported for each listed OS, and the component version when installation and upgrade became invalid.
The operating systems in the table include service packs and updates.
|Operating system||Component/feature||Latest valid version||Install/upgrade not possible as of version|
|Windows 7 and Windows 8||VDA||7.15 LTSR||7.16|
|Windows 7 and Windows 8||Other installer components||7.17||7.18|
|Windows 10 versions earlier than 1607||VDA||7.15 LTSR||7.16|
|Windows 10 x86 version||VDA||1906.2.0||1909|
|Windows Server 2008 R2||VDA||7.15 LTSR||7.16|
|Windows Server 2008 R2||Other installer components||7.17||7.18|
|Windows Server 2012||VDA||7.15 LTSR||7.16|
|Windows Server 2012||Other installer components||7.17||7.18|
|Windows Server 2012 R2||Other installer components *||1912 LTSR||2003|
|Windows Server 2012 R2||Server VDI||7.15 LTSR||7.16|
Windows XP and Windows Vista are not valid for any 7.x components or technologies.
* Applies to Delivery Controller, Studio, Director, and VDAs.
What you can do
You have choices. You can:
- Continue with the current OS
- Reimage or upgrade the machine
- Add new machines and then remove old machines
Continue with the current OS
These methods are feasible for VDAs. If you want to continue using machines with the earlier OS, you can choose one of the following:
- Continue using the installed component version.
- Download the latest valid component version and then upgrade the component to that version. (This assumes that the latest valid component version isn’t already installed.)
For example, you have a 7.14 VDA on a Windows 7 SP1 machine. The latest valid VDA version on Windows 7 OS machines is XenApp and XenDesktop 7.15 LTSR. You can either continue using 7.14, or download a 7.15 LTSR VDA and then upgrade your VDA to that version. Those earlier VDA versions work in deployments containing Delivery Controllers with newer versions. For example, a 7.15 LTSR VDA can connect to a Citrix Virtual Apps and Desktops 7 1808 Controller.
Reimage or upgrade the machine
These methods are feasible for VDAs and other machines that do not have core components (such as Delivery Controllers) installed. Choose one of the following:
- After taking the machine out of service (turning on maintenance mode and allowing all sessions to close), you can reimage it to a supported Windows OS version, and then install the latest version of the component.
- To upgrade the OS without reimaging, uninstall the Citrix software before upgrading the OS. Otherwise, the Citrix software will be in an unsupported state. Then, install the new component.
Add new machines and then remove old machines
This method is feasible if you must upgrade the OS on machines containing a Delivery Controller or other core component.
Citrix recommends that all Controllers in a site have the same OS. The following upgrade sequence minimizes the interval when different Controllers have different OSs.
- Take a snapshot of all Delivery Controllers in the site and then back up the site database.
- Install new Delivery Controllers on clean servers with supported operating systems. For example, install a Controller on two Windows Server 2016 machines.
- Add the new Controllers to the site.
- Remove the Controllers that are running on operating systems that are not valid for the current release. For example, remove two Controllers on two Windows Server 2008 R2 machines. Follow the recommendations for removing Controllers in Delivery Controllers.
Before beginning an upgrade, review the following information and complete necessary tasks.
Choose an installer and interface
Use the full-product installer from the product ISO to upgrade components. You can upgrade VDAs using the full-product installer or one of the standalone VDA installers. All installers offer graphical and command line interfaces.
For more information, see Installers.
Installation specifics: After you complete any preparation work and are ready to start the installer, the installation article shows you what you will see (if you’re using the graphical interface) or what to type (if you’re using the command-line interface).
- Install/upgrade core components using the graphical interface
- Install/upgrade core components using the command line
- Install/upgrade VDAs using the graphical interface
- Install/upgrade VDAs using the command line
If you originally installed a single-session VDA with the
VDAWorkstationCoreSetup.exe installer, Citrix recommends using that installer to upgrade it. If you use the full-product VDA installer or the
VDAWorkstationSetup.exe installer to upgrade the VDA, the components that were originally excluded might be installed, unless you expressly omit/exclude them from the upgrade.
When upgrading a VDA to this release, a machine restart occurs during the upgrade process. (This requirement started with the 7.17 release.) This cannot be avoided. The upgrade resumes automatically after the restart (unless you specify
/noresume on the command line).
Back up the site, monitoring, and configuration logging databases. Follow the instructions in CTX135207. If any issues are discovered after the upgrade, you can restore the backup.
For information about upgrading SQL Server versions that are no longer supported, see SQL Server version check. (This refers to the SQL Server that is used for the site, monitor, and configuration logging databases.)
Microsoft SQL Server Express LocalDB is installed automatically, for use with Local Host Cache. If you need to replace an earlier version, the new version must be at least SQL Server Express 2017 LocalDB CU16. For details about replacing SQL Server Express LocalDB with a new version after you upgrade the components and the site, see Replace SQL Server Express LocalDB.
Ensure that your Citrix licensing is up-to-date
For a comprehensive look at managing Citrix Licensing, see Activate, upgrade, and manage Citrix licenses.
You can use the full-product installer to upgrade the License Server. Or, you can download and upgrade the license components separately. See Upgrade.
Before upgrading, be sure your Customer Success Services / Software Maintenance / Subscription Advantage date is valid for the new product version. If you are upgrading from an earlier 7.x product version, the date must be at least 2019.1115.
Ensure that your Citrix License Server is compatible
Ensure that your Citrix License Server is compatible with the new version. There are two ways to do this:
Before upgrading any other Citrix components, run the
XenDesktopServerSetup.exeinstaller from the ISO layout on the machine containing a Delivery Controller. If there are any incompatibility issues, the installer reports it with recommended steps to resolve the issues.
XenDesktop Setupdirectory on the installation media, run the command:
.\LicServVerify.exe -h <license-server-fqdn> -p 27000 -v.The display indicates whether the License Server is compatible. If the License Server is incompatible, upgrade the license server.
Back up any StoreFront modifications
Before starting an upgrade, if you have made modifications to files in
C:\inetpub\wwwroot\Citrix\<StoreName>\App_Data, such as default.ica and usernamepassword.tfrm, back them up for each store. After the upgrade you can restore them to reinstate your modifications.
Close applications and consoles
Before starting an upgrade, close all programs that might potentially cause file locks, including administration consoles and PowerShell sessions.
Restarting the machine ensures that any file locks are cleared, and that there are no Windows updates pending.
Before starting an upgrade, stop and disable any third-party monitoring agent services.
Ensure that you have proper permissions
In addition to being a domain user, you must be a local administrator on the machines where you are upgrading product components.
The site database and the site can be upgraded automatically or manually. For an automatic database upgrade, the Studio user’s permissions must include the ability to update the SQL Server database schema (for example, the
db_owner database role). For details, see Databases.
If the Studio user does not have those permissions, initiating a manual database upgrade generates scripts. The Studio user runs some of the scripts from Studio. The database administrator runs other scripts, using a tool such as SQL Server Management Studio.
Other preparation tasks
- Back up templates and upgrade hypervisors, if needed
- Complete any other preparation tasks dictated by your business continuity plan.
Preliminary site tests
When you upgrade Delivery Controllers and a site, preliminary site tests run before the actual upgrade begins. These tests verify:
- The site database can be reached and has been backed up
- Connections to essential Citrix services are working correctly
- The Citrix License Server address is available
- The configuration logging database can be reached
After the tests run, you can view a report of the results. You can then fix any issues that were detected, and run the tests again. Failure to run the preliminary site tests and then resolve any issues can impact how your site works.
The report containing the test results is an HTML file (
PreliminarySiteTestResult.html) in the same directory as the installation logs. That file is created if it does not exist. If the file exists, its content is overwritten.
Run the tests
- When you’re using the installer’s graphical interface to upgrade, the wizard includes a page where you can start the tests and then display the report. After the tests run and you have viewed the report and resolved any issues that were found, you can rerun the tests. When the tests complete successfully, click Next to continue with the wizard.
- When you’re using the command-line interface to upgrade, the tests run automatically. By default, if a test fails, the upgrade is not performed. After you view the report and resolve issues, rerun the command.
Citrix recommends always running the preliminary site tests and then resolving any issues before you continue the Controller and site upgrade. The potential benefit is well worth the few moments to run the tests. However, you can override this recommended action.
- When upgrading with the graphical interface, you can choose to skip the tests and continue with the upgrade.
- When upgrading from the command line, you cannot skip the tests. By default, a failed site test causes the installer to fail, without performing the upgrade. In most cases, if you include the
/ignore_site_test_failureoption, any test failures are ignored and the upgrade proceeds. (See SQL Server version check for exceptions.)
When upgrading multiple Controllers
When you start an upgrade on one Controller, and then start an upgrade of another Controller in the same site (before the first upgrade completes):
- If the preliminary site tests have completed on the first Controller, the preliminary site tests page does not appear in the wizard on the other Controller.
- If the tests on the first Controller are ongoing when you start the upgrade on the other Controller, the site tests page appears in the wizard on the other Controller. However, if the tests on the first Controller finish, only the test results from the first Controller are retained.
Test failures not related to the site’s health
- If the preliminary site tests fail due to insufficient memory, make more memory available and then rerun the tests.
- If you have permission to upgrade, but not run site tests, the preliminary site tests fail. To resolve this, rerun the installer with a user account that has permission to run the tests.
SQL Server version check
A successful Citrix Virtual Apps and Desktops deployment requires a supported version of Microsoft SQL Server for the site, monitor, and configuration logging databases. Upgrading a Citrix deployment with a SQL Server version that’s no longer supported can result in functionality issues, and the site will be unsupported.
To learn which SQL Server versions are supported for the Citrix release you’re upgrading to, see the System requirements article for that release.
When upgrading a Controller, the Citrix installer checks the currently installed SQL Server version used for the site, monitor, and configuration logging databases.
If the check determines that the currently installed SQL Server version is not a supported version in the Citrix release you’re upgrading to:
- Graphical interface: The upgrade halts with a message. Click I understand and then click Cancel to close the Citrix installer. (You cannot continue with the upgrade.)
- Command-line interface: the command fails (even if you included the
/ignore_db_check_failureoption with the command).
Upgrade the SQL Server version, and then start the Citrix upgrade again.
If the check cannot determine which SQL Server version is currently installed, see if your currently installed version is supported in the version you’re upgrading to (System requirements).
Graphical interface: The upgrade halts with a message.
- If the currently installed SQL Server version is supported, click I understand to close the message, and then click Next to continue with the Citrix upgrade.
- If the currently installed SQL Server version is not supported, click I understand to close the message, and then click Cancel to end the Citrix upgrade. Upgrade your SQL Server to a supported version and then start the Citrix upgrade again.
Command-line interface: The command fails with a message. After closing the message:
- If the currently installed SQL Server version is supported, run the command again with the
- If the currently installed SQL Server version is not supported, upgrade your SQL Server to a supported version. Run the command again to start the Citrix upgrade.
- If the currently installed SQL Server version is supported, run the command again with the
Upgrading SQL Server
If you bring up new SQL Server servers and migrate the site database, then connection strings must be updated.
If the site currently uses SQL Server Express (that Citrix installed automatically during site creation):
- Install the latest SQL Server Express version.
- Detach the database.
- Attach the database to the new SQL Server Express.
- Migrate connection strings.
For more information, see Configuring connection strings and the Microsoft SQL Server product documentation.
Replace SQL Server Express LocalDB
Microsoft SQL Server Express LocalDB is a feature of SQL Server Express that Local Host Cache uses on a standalone basis. Local Host Cache does not require any components of SQL Server Express other than SQL Server Express LocalDB.
If you installed a Delivery Controller version earlier than 1912 and then upgrade your deployment to version 1912 or later, Citrix does not automatically upgrade the SQL Server Express LocalDB version. Why not? Because you might have non-Citrix components that rely on SQL Server Express LocalDB. If you have non-Citrix components that are using SQL Server Express LocalDB, ensure that upgrading SQL Server Express LocalDB does not disrupt those components. To upgrade (replace) the SQL Server Express LocalDB version, follow the guidance in this section.
When upgrading Delivery Controllers to Citrix Virtual Apps and Desktops version 1912, 1912 LTSR, or 2003: Upgrading SQL Server Express LocalDB is optional. Local Host Cache works properly, with no loss of functionality, regardless of whether you upgrade SQL Server Express LocalDB. We added the option to move to a newer version of SQL Server Express LocalDB in case there are concerns about end of support from Microsoft for SQL Server Express LocalDB 2014.
When upgrading Delivery Controllers to Citrix Virtual Apps and Desktops versions newer than 2003: The minimum supported version is SQL Server Express 2017 LocalDB Cumulative Update (CU) 16. If you originally installed a Delivery Controller earlier than version 1912, and have not replaced SQL Server Express LocalDB with a newer version since then, you must replace that database software now. Otherwise, Local Host Cache will not work.
What you need:
- The Citrix Virtual Apps and Desktops installation media (for the version you’ve upgraded to). The media contains a copy of Microsoft SQL Server Express LocalDB 2017 CU 16.
- A Windows Sysinternals tool that you download from Microsoft.
- Complete the upgrade of your Citrix Virtual Apps and Desktops components, databases, and site. (Those database upgrades affect the site, monitoring, and configuration logging databases. They do not affect the Local Host Cache database that uses SQL Server Express LocalDB.)
- On the Delivery Controller, download
PsExecfrom Microsoft. See the Microsoft document PsExec v2.2.
- Stop the Citrix High Availability Service.
From the command prompt, run
PsExecand switch to the Network Service account.
psexec -i -u "NT AUTHORITY\NETWORK SERVICE" cmd
Optionally, you can use
whoamito confirm that the command prompt is running as the Network Service account.
nt authority\network service
Move to the folder containing SqlLocalDB.
cd "C:\Program Files\Microsoft SQL Server\120\Tools\Binn"
Stop and delete
SqlLocalDB stop CitrixHA
SqlLocalDB delete CitrixHA
Remove the related files in
HADatabaseName.* HADatabaseName_log.* HAImportDatabaseName.* HAImportDatabaseName_log.* <!--NeedCopy-->
Tip: Your deployment might not have
- Uninstall SQL Server Express LocalDB 2014 from the server, using the Windows feature for removing programs.
- Install SQL Server Express LocalDB 2017. In the
Support > SQLLocalDBfolder on the Citrix Virtual Apps and Desktops installation media, double-click
sqllocaldb.msi. A restart might be requested to complete the installation. (The new SQLLocalDB resides in
C:\Program Files\Microsoft SQL Server\140\Tools\Binn.)
- Start the Citrix High Availability Service.
Ensure that the Local Host Cache database was created on each Delivery Controller. This confirms that the High Availability Service (secondary broker) can take over, if needed.
- On the Controller server, browse to
- Verify that
- On the Controller server, browse to