Configure SQL Server 编辑

For connections to SQL Server from an on-premises XenMobile Server, you can use any of the following drivers:

  • The default driver
  • jTDS
  • Microsoft Java Database Connectivity (JDBC) driver

The jTDS driver is the default driver when you:

  • Install XenMobile Server on-premises.
  • 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 (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 for Microsoft.

    Image of choosing JDBC driver

  5. When prompted, type y to choose SQL authentication and then 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.

To change the XenMobile database password

Follow this guidance to change the XenMobile database password, such as when Citrix Support directs you to make a password change.

If your SQL server uses Windows authentication, make database password changes in Windows Active Directory. Then, refresh the database administrator account on the database server to synchronize the password change. You can then change the password in XenMobile, as follows.

Important:

  • Plan a scheduled maintenance window for changing the database password in XenMobile. A password change must occur during system downtime.
  • When you change the password, ensure that all XenMobile nodes are connected to the network. After you change the password, restart XenMobile.

    If you don’t restart XenMobile after a password change, XenMobile goes into recovery mode. In that case, revert to the old password in SQL server, restart XenMobile, and change the password again.

  1. Verify that all XenMobile Server nodes are running. For a clustered environment, bring up all nodes.

  2. Block the incoming device traffic to XenMobile at the Citrix ADC load balancer by disabling the virtual server.

  3. To change the database password in SQL server: Log in to the XenMobile CLI, navigate to Configuration > Database, and enter the changed password when prompted:

    Server []: <ipAddress>
    Port [1433]: 1433
    Username [sa]: <userName>
    Password: <****>
    <!--NeedCopy-->
    

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据

词条统计

浏览:65 次

字数:5563

最后编辑:8年前

编辑次数:0 次

    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
    原文