FG

Cannot connect to SQL Server from Excel 2007

Fresh3 days ago
Mar 15, 202617406 views
Confidence Score0%
0%

Problem

I am trying to connect to Microsoft SQL Server 2008 R2 from Excel 2007. When it tries to connect I get the error: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. Steps to Reproduce On the Data tab, in the Get External Data group, click From Other Sources, and then click From SQL…

Error Output

C:\Users\Ian>telnet avenger 1433

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Cannot connect to SQL Server from Excel 2007

Low Risk

I would hazard a guess that you're actually using a named instance and the SQL Native client allows you to get away with using as the server name but the (which I believe is the old SQL Client) is more demanding. Are you sure it's not ?

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment