How to fix "The Remote Computer Refused the Network Connection"

Question

Since upgrading to Windows 11, we got this issue connecting to a SQL Server 2019 using availability group listener. See full error below from SQL Management Studio.

TITLE: Connect to Server

---

Cannot connect to prdlsngaip,5039.

---

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-1225-database-engine-error

---

The remote computer refused the network connection

---

It only works when we specify "tcp:" before the listener or use the full FQDN, which is currently not how we connect to SQL servers.

Per MS Support Engineers that worked with me I need to use the tcp or disable credential guard setting which is enabled by default in windows 11.

There are no firewall rules blocking this and this also used to work perfectly before upgrading to Windows 11. I would like to know if I have other options. Thank you