I just installed a new environment in my lab to test out the latest release of Citrix Provisioning, version 7-1811. After installation and configuration of my PVS farm, I noticed that my Stream Service appeared to be offline, yet the Windows Service was running.
Came across the error message in the Windows Application Event Log. “Undefined database error. This is an internal error. Please contact technical support.”
Found the solution via CTX226526 and CTX232573 which point you to download the latest SQL Native Client from Microsoft: https://www.microsoft.com/en-us/download/details.aspx?id=50402
Once the client is updated, the services start right up and connect to the SQL database. In my case, I’m running Microsoft SQL Server 2016 on Windows Server 2016.
Hope this help, thanks for reading.