book
Article ID: CTX231029
calendar_today
Updated On:
Description
Health Check has detected a broken database connection for one of the following XenApp/XenDesktop Controller Services:
ADIdentity Service
Analytics Service
AppLibrary Service
Broker Service
Configuration Service
Delegated Admin Service
Environment Test Service
Host Availability Service
Machine Creation Service
Monitor Service
StoreFront Service
Trust Service
Orchestration Service
For more information about these services, refer to CTX139415- XenDesktop 7.x Services Overview
Resolution
Perform the following tasks to repair the broken database connection:
- Verify that the database server is running, and reachable on the network.
- Check the hostname of the database server in the string and the database name on the database server.
- Look for any corruption or issues with the database. Refer to CTX127998 - Database Access and Permission Model for XenDesktop
- On the Delivery Controller, open a PowerShell command window.
- Type `asnp Citrix*
- Ensure that the connection string is configured correctly, and that the database server is healthy and up and running by <INSERT>
- Get-[Service]DBConnection -DataStore Site (for services with secondary database) Monitor, Log.
- Get-[Service]DBConnection
- If incorrect, null the connection, set the connection
- Ensure that the Delivery Controller can communicate with the database server. by <INSERT>
- Ping,
- Restart the service Citrix Monitor service by <INSERT>
- Ensure the permissions on the database is configured correctly. Refer to CTX127998 - Database Access and Permission Model for XenDesktop
Problem Cause
A database connection string has been specified for the Controller Service, but the database is not compatible or working properly.