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

0 users found this article helpful

Symptoms

This message is seen in the console of the Awingu 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 Awingu appliance is running on Microsoft Hyper-V and if 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 Awingu appliance.


Checking the Microsoft SQL Settings when the appliance is down

Important to note: 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 'AWINGU' to the database name that is being used for Awingu.
SELECT * FROM [AWINGU].[dbo].[configuration_configuration]

Was this article helpful?

Tell us how we can improve it.