Product Documentation

SQL Server drivers

Dec 01, 2017

XenMobile Service uses the jTDS driver for connections to SQL Server.

As of XenMobile Server 10.7 RP 2: For connections to SQL Server from an on-premises XenMobile Server, you can use the default driver, jTDS, or the Microsoft Java Database Connectivity (JDBC) driver. The jTDS driver is the default driver when you install XenMobile Server on-premises or upgrade from a XenMobile Server that’s configured to use the jTDS driver.

For both drivers, XenMobile supports SQL Server authentication or Windows authentication. For those combinations of authentication and driver, SSL can be on or off.

When you use Windows authentication with the Microsoft JDBC driver, the driver uses integrated authentication with Kerberos. XenMobile contacts Kerberos to obtain the Kerberos Key Distribution Center (KDC) details. If the required details aren’t available, the XenMobile CLI prompts for the IP address of the Active Directory server.

To switch from the jTDS driver to the JDBC driver, SSH to all your XenMobile Server nodes and use the XenMobile CLI for configuration. The steps vary according to your current jTDS driver configuration, as follows.

Switch to Microsoft JDBC (SSL is off; SQL Server authentication)

To complete these steps, you need the SQL Server user name and password.

SSH to all XenMobile Server nodes.

In the XenMobile CLI main menu, type 2 to select the System Menu.

Type 12 to select Advanced Settings.

Type 7 to select Switch JDBC driver, and then type m for Microsoft or j for jTDS.

localized image

When prompted, type y to choose SQL authentication and then type the SQL Server user name and password.

Repeat the steps for each XenMobile Server node.

Restart each XenMobile Server node.

Switch to Microsoft JDBC (SSL is off; SQL Server authentication)

To complete these steps, you need the SQL Server user name and password.

  1. SSH to all XenMobile Server nodes.
  2. In the XenMobile CLI main menu, type 2 to select the System Menu.
  3. Type 12 to select Advanced Settings.
  4. Type 7 to select Switch JDBC driver, and then type m.
  5. When prompted, type the SQL Server user name and password.
  6. Repeat the steps for each XenMobile Server node.
  7. Restart each XenMobile Server node.

Switch to Microsoft JDBC (SSL is off; Windows authentication)

To complete these steps, you need the Active Directory user name and password, the Kerberos KDC realm, and the KDC user name.

  1. SSH to all XenMobile Server nodes.
  2. In the XenMobile CLI main menu, type 2 to select the System Menu.
  3. Type 12 to select Advanced Settings.
  4. Type 7 to select Switch JDBC driver, and then type m.
  5. When prompted whether to use SQL Server authentication, type n.
  6. When prompted, type the Active Directory user name and password configured for the SQL server.
  7. If XenMobile doesn’t auto-discover the Kerberos KDC realm, it prompts for the KDC details, including the SQL server FQDN.
  8. When prompted whether to use SSL, type n. XenMobile saves the configuration. If XenMobile can’t save the configuration because of errors, it shows an error message and the details that you entered.
  9. Repeat the steps for each XenMobile Server node.
  10. Restart each XenMobile Server node.