Product Documentation

Supporting Named SQL Instances

Feb 11, 2016

You can use the Upgrade Tool to upgrade from XenMobile 9 to XenMobile 10 and from XenMobile 9 to XenMobile 10.1. If your XenMobile 9 setup is based on named SQL instances, you need to follow steps specific to this situation. If your XenMobile 9 environment meets the following prerequisites, follow the steps in this article to upgrade. 

  • XenMobile 9 MDM Edition or Enterprise Edition set up with an external SQL Server database.
  • SQL Server database running on a non-default named instance.
  • SQL Server named instance listening on a static or dynamic TCP port. You can confirm this prerequisite by looking at the IP addresses of the TCP/IP protocol of the named instance as shown in the following figures. 

注意

Citrix recommends that the SQL server database instance always runs on a static port, because the XenMobile server needs continuing access to the database. This connection generally traverses through a firewall. As a result, you need to open the appropriate port in the firewall; therefore, you the need to have the database instance running on a static port.

localized image
localized image

Steps to upgrade XenMobile with a SQL Server named instance

1. Go to the Device Manager installation directory and open the ew-config.properties file. This file is available in tomcat\webapps\zdm\WEB-INF\classes.

localized image

2.     In the ew-config.properties file, search for the following URLs in the DATASOURCE Configuration section:

pooled.datasource.url= jdbc:jtds:sqlserver://<SQLserver_FQDN>/<DB_Name>;instance=<Instance_Name>

audit.datasource.url= jdbc:jtds:sqlserver://<SQLserver_FQDN>/<DB_Name>;instance=<Instance_Name>

localized image

3.     Remove the instance name in the preceding URLs and add the port along with the SQL Server FQDN. In this case, 64940 is the required port. 

pooled.datasource.url=jdbc:jtds:sqlserver:// <SQLserver_FQDN>:64940/<DB_Name>

audit.datasource.url=jdbc:jtds:sqlserver:// <SQLserver_FQDN>:64940/<DB_Name>

Add “;domain=<DomainSuffix>” to the end of URL if the user account belongs to a domain.

注意

Citrix recommends that you make a backup, copy, or note of the changes you make in the ew-config.properties file. This information is helpful in case the migration fails.

localized image

4.      Restart the Device Manager service. Refresh the device connections when the Device Manager instance returns. 

localized image

5. Determine if the new XenMobile 10 server also needs to work with named SQL instance. If so, identify the port on which the named instance is running. If the port is a dynamic port, Citrix recommends that you convert the port to a static port; then, configure the static port on the new XenMobile server as part of the database setup.

localized image

6. Follow the steps in these articles to continue upgrading your XenMobile environment: