FreeTDS: Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnect)

1 users found this article helpful

Symptoms

This message is seen in the console of the Parallels Secure Workspace appliance (virtual machine) - this may require the appliance to be rebooted first:


[08S01] [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnect)

Cause

Resolution

When the appliance is running on Microsoft Hyper-V and July 2022 updates have been installed:

There's a known issue when Microsoft Hyper-V is patched with the July 2022 updates in combination with using a Named Instance, which results in UDP traffic not reaching the Microsoft SQL Server. Related Microsoft KBs include - but may not be limited to - KB5015807, KB5015808.


There are two options:


Else:

Verify connectivity based on the Microsoft SQL Settings of the Parallels Secure Workspace appliance.


Checking the Microsoft SQL Settings when the appliance is down

Important: it's not possible to simply adjust the settings in the database table.
On the Microsoft SQL Server, run this SQL query to confirm the database settings:

# Adjust 'WORKSPACE' to the database name that is being used for Parallels Secure Workspace.
SELECT * FROM [WORKSPACE].[dbo].[configuration_configuration]

Was this article helpful?

Tell us how we can improve it.