Why does Excel show ‘Data Source Not Found’ when you paste your perfectly valid connection string? Why does the same query work in SSMS but return zero rows in Power Query? Why does it connect on your laptop but fail silently on the shared workstation?
The answer isn’t permissions, drivers, or even your SQL credentials—it’s that Excel doesn’t actually connect to SQL Server the way you think it does. It layers three distinct protocols (ODBC, OLE DB, and native Power Query), and most people pick the wrong one for their environment—then waste hours troubleshooting the wrong layer.
The Setup
We’ll use a real sales operations dataset from Acme Corp’s internal SQL Server instance (ACMESVR03\PROD). This table lives in [SalesDB].[dbo].[QuarterlyOrders] and contains live order data synced nightly. No dummy data—this is what Sarah Chen in Finance pulls every Thursday at 9:15 a.m. before her team sync.
| OrderID | CustomerName | ProductCode | Amount | OrderDate | Region |
|---|---|---|---|---|---|
| ORD-78241 | Sarah Chen | PRM-2201 | $24,500 | 2024-03-12 | APAC |
| ORD-78242 | James Rios | BAS-1988 | $8,950 | 2024-03-14 | EMEA |
| ORD-78243 | Lena Park | PRM-2201 | $31,200 | 2024-03-15 | AMER |
| ORD-78244 | David Mwangi | BAS-1988 | $12,600 | 2024-03-16 | APAC |
| ORD-78245 | Nina Dubois | PRM-2201 | $45,200 | 2024-03-17 | EMEA |
| ORD-78246 | Tariq Hassan | ADV-3055 | $68,900 | 2024-03-18 | AMER |
| ORD-78247 | Elena Rossi | BAS-1988 | $9,300 | 2024-03-19 | EMEA |
| ORD-78248 | Kenji Tanaka | PRM-2201 | $27,400 | 2024-03-20 | APAC |
The Challenge
You need live access to this data—but not via copy-paste. Finance wants refreshable reports. Sales needs filters by Region and OrderDate. And IT says “no third-party tools.” That means no SSIS, no Python scripts, no Power BI Desktop. Just Excel—and whatever’s built-in.
Here’s what trips people up: They click Data > Get Data > From Database > From SQL Server Database, enter ACMESVR03\PROD, then hit OK—and get a blank dialog. Or worse: they get past authentication only to see 0 rows, even though SELECT TOP 10 * FROM [QuarterlyOrders] returns results in SSMS instantly.
The root cause? Excel defaults to Windows Authentication—and your domain account has access to the server, but not to the SalesDB database specifically. Or you’re on a non-domain machine (like a contractor’s laptop) and need SQL Auth—but the wizard hides the option unless you edit the connection string manually.
Walking Through It
We’ll use Power Query (the most reliable method). Start fresh: open a new workbook. Go to Data > Get Data > From Database > From SQL Server Database. Don’t type anything yet.
Now—here’s the counterintuitive part: Click Cancel. Yes, cancel the dialog. Then press Alt + D + B. This opens the legacy Existing Connections dialog. Click Add Connection > SQL Server.
You’ll now see a field labeled Server name. Enter ACMESVR03\PROD. Below that, check Use database name and type SalesDB. Now click Advanced. Paste this into the connection string box:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SalesDB;Data Source=ACMESVR03\PROD;
If you need SQL auth instead, replace the Integrated Security=SSPI part with User ID=sqluser;Password=MyP@ssw0rd1!. Then click OK → OK → Load.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Cancel initial wizard, press Alt+D+B | Opens legacy connection manager | Alt+D+B |
| 2 | Add new SQL Server connection, set Initial Catalog=SalesDB | Prevents 'database not found' errors | — |
| 3 | Click Advanced, paste full connection string | Enables SQL Auth and bypasses UI limitations | — |
| 4 | Click OK twice, then Load | Data appears in Sheet1, starting at A1 | Enter |
The Result
After loading, you’ll see all 8 rows in columns A–F, exactly matching the source table. The connection is saved. To refresh later: right-click any cell in the data range → Refresh. Or press Alt + F5.
This isn’t static copy-paste. It’s a live link. If Sarah Chen updates ORD-78241’s Amount to $25,100 in SQL Server tonight, tomorrow morning’s refresh pulls that change automatically. No re-running queries. No manual exports.
| OrderID | CustomerName | ProductCode | Amount | OrderDate | Region |
|---|---|---|---|---|---|
| ORD-78241 | Sarah Chen | PRM-2201 | $24,500 | 2024-03-12 | APAC |
| ORD-78242 | James Rios | BAS-1988 | $8,950 | 2024-03-14 | EMEA |
| ORD-78243 | Lena Park | PRM-2201 | $31,200 | 2024-03-15 | AMER |
| ORD-78244 | David Mwangi | BAS-1988 | $12,600 | 2024-03-16 | APAC |
| ORD-78245 | Nina Dubois | PRM-2201 | $45,200 | 2024-03-17 | EMEA |
| ORD-78246 | Tariq Hassan | ADV-3055 | $68,900 | 2024-03-18 | AMER |
| ORD-78247 | Elena Rossi | BAS-1988 | $9,300 | 2024-03-19 | EMEA |
| ORD-78248 | Kenji Tanaka | PRM-2201 | $27,400 | 2024-03-20 | APAC |
What Could Go Wrong
Mistake #1: Using the new wizard without specifying Initial Catalog
Excel tries to list databases—but if your login lacks VIEW ANY DATABASE permission (common for production accounts), it shows an empty dropdown or throws “Cannot connect to server.” You’ll stare at a blank dialog for 12 minutes before giving up.
Mistake #2: Assuming Windows Auth works everywhere
It works on your domain-joined desktop. But if you open the same file on a Mac (via Excel Online), or on a vendor’s machine outside the firewall, Windows Auth fails silently—and Excel doesn’t tell you why. You just get zero rows.
Mistake #3: Forgetting to enable TCP/IP in SQL Server Configuration Manager
This isn’t an Excel issue—but if your DBA disabled TCP/IP (leaving only Named Pipes), then ACMESVR03\PROD won’t respond to Excel’s default OLE DB provider. The error message? “A network-related or instance-specific error…”—which sends you down a DNS rabbit hole for hours.
Next step: Open Excel right now and try Alt + D + B. Paste your server name, add Initial Catalog=YourDBName to the connection string, and test with a simple SELECT TOP 5 * FROM sys.tables. If that loads, you’ve got the foundation. Everything else is filtering and formatting.
