PVS Servers Show Offline on PVS Console - Event ID 11 - Undefined Database Error

PVS Servers Show Offline on PVS Console - Event ID 11 - Undefined Database Error

book

Article ID: CTX226526

calendar_today

Updated On:

Description

PVS server shows offline in the PVS console, although Streaming service is running on occasion:

An error in event viewer:

Event ID: 11 – Undefined database error/PVS server status is "Down"

This is an internal error. Please contact technical support.

Environment

Citrix is not responsible for and does not endorse or accept any responsibility for the contents or your use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever Web site you use is free of viruses or other harmful items.

Resolution

Complete the following steps:

  1. Restart  Citrix PVS Soap Server
  2. Check Supported Databases for Virtual Apps and Desktops AND Citrix Provisioning (PVS)

    https://support.citrix.com/s/article/CTX114501-supported-databases-for-virtual-apps-and-desktops-and-citrix-provisioning-pvs?language=en_US

    Note: 

    SQL Server Native Client support is removed from Citrix Provisioning 2109 and later and not required anymore 

    Microsoft OLE DB Driver is now installed with specific Citrix Provisioning versions

    reference: https://docs.citrix.com/en-us/provisioning/current-release/system-requirements#database
  3. Check root and intermediate certificate of SQL server, from the affected PVS server.
  4. If required request a certificate from your local domain Certificate Authority and apply it to the SQL server hosting the PVS database. 
  5. Create SPN hostnames for the SQL server's domain account in the AD (SPN hostnames should get created automatically when you installed SQL Server role)
  6. Re-run the Citrix Provisioning configuration Wizard again.

If the issue still occurs: collect logs and upload to  MyCitrix Account

     

    Issue/Introduction

    PVS servers showing offline with an error in event viewer with event ID 11 - Undefined database error./PVS server status is "Down"

    Additional Information

    https://learn.microsoft.com/en-us/sql/connect/oledb/major-version-differences?view=sql-server-ver16#encryption-property-changes

    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/manage-certificates?view=sql-server-ver16