Upgraded to Windows 11 from Windows 10, Excel Macro that fetches SQL data no longer works

Jimmy Jimenez 0

Windows 11 Excel macro connect to sql server 2008 not working.

Receiving System Error &H80004005 (-2147467259). Unspecified error.

Any ideas on how to get this to work? The Excel macro works from Windows 10.

Erland Sommarskog 117.5K Reputation points MVP

2025-02-25T22:27:49.8566667+00:00

The most likely explanation is that Windows 11 only uses TLS 1.2 and SQL 2008 may not have that support. What does SELECT @@version return?
Jimmy Jimenez 0 Reputation points

2025-02-25T22:35:27.9833333+00:00

I've been reading that Windows 11 only uses TLS 1.2 and that could be my problem. Unfortunately, I cannot upgrade this SQL server and am searching for a workaround.

When I run the SELECT I get, "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0"
Jimmy Jimenez 0 Reputation points

2025-02-25T22:44:05.17+00:00

I've been reading that Windows 11 only using TLS 1.2 could be my problem. Unfortunately for me, I cannot update the SQL server to a new version.

When I run the SELECT command I get, "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0."

1 answer