SQL Connection Errors
14 articles
Troubleshooting MFA (Multi-Factor Authentication) prompts that break background refreshes.
Multi-Factor Authentication (MFA) prompts that break background refreshes occur when automated tasks, VBA macros, or Power…
Handling “The connection has been disabled” in Excel Trust Center settings.
The error “The connection has been disabled” (or the message bar warning “Security Warning: External Data…
Fixing “Microsoft.ACE.OLEDB.16.0 provider is not registered” for Access/SQL hybrids.
The error “The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine” appears when Excel, Power…
Fixing “The driver does not support the version of TDS that the server is using.”
The error “The driver does not support the version of TDS that the server is using”…
How to resolve “Encryption mismatch” between Excel and legacy SQL Server versions.
The error “Encryption mismatch” (frequently appearing as “A connection was successfully established with the server, but…
Troubleshooting VPN-related connection drops during Power Query refreshes.
VPN-related connection drops during Power Query refreshes occur when large tabular datasets overwhelm the virtual private…
Fixing “TCP Provider: No connection could be made because the target machine actively refused it.”
The error “TCP Provider: No connection could be made because the target machine actively refused it”…
Handling “Access to the resource is forbidden” in Azure SQL Database links.
The error “Access to the resource is forbidden” occurs when Excel or Power Query successfully discovers…
Solving SSL Provider errors: “The certificate chain was issued by an untrusted authority.”
The error “SSL Provider: The certificate chain was issued by an untrusted authority” occurs when Excel,…
Troubleshooting “Named Pipes Provider: Could not open a connection to SQL Server.”
The error “Named Pipes Provider: Could not open a connection to SQL Server” (often accompanied by…
Fixing “The provider ‘SQLNCLI11’ is not registered” on 64-bit systems.
The error “The provider ‘SQLNCLI11’ is not registered” occurs when 64-bit Excel, Power Query, or a…
Troubleshooting “Deadlocked” connections when Excel and SQL compete for resources
A SQL deadlock occurs when an Excel refresh and another database transaction hold locks on separate…