Installing or upgrading to XenApp and XenDesktop Site version 7.18 with a SQL Server 2008 R2 for Monitor database results in a failure.

Description:
If you are using SQL Server 2008 R2 as Monitor database for XenApp and XenDesktop then, installing or upgrading the XenApp and XenDesktop Site to version 7.18 results in a failure. Here’s the log message shown on Citrix Studio Console:
 
Inner Exception:
    System.Data.SqlClient.SqlException 'CONCAT' is not a recognized built-in function name.
    'CONCAT' is not a recognized built-in function name.
    Incorrect syntax near the keyword 'END'.
       at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
 
 

Before you install or upgrade to XenApp and XenDesktop version 7.18, do one of the following:

• Upgrade your SQL server deployments to use SQL Server version 2012 or later.

 Or,

Download the patched MonitorServiceMSI.zip attached to this article. Follow the steps below to replace the same in the XenApp and XenDesktop v7.18 layout: 

For a 32-bit OS, use the patched Monitor_Service_x86.msi file, and for a 64-bit OS use the Monitor_Service_x64.msi file.

1. Extract the XenApp and XenDesktop 7.18 ISO. 
2. In case of a 32-bit OS, in the x86\Citrix Desktop Delivery Controller folder, replace the Monitor_Service_x86.msi file with the patched file. In case of a 64-bit OS, in the x64\Citrix Desktop Delivery Controller folder, replace the Monitor_Service_x64.msi file with the patched file
3. Double click \image-full\AutoSelect.exe to begin installation or upgrade.