Linked server queries that use MSDASQL fail with error 7416
Linked server queries that use the MSDASQL (OLE DB Provider for ODBC Drivers) provider and specify a provider string (@provstr) fail and return the following error message: Msg 7416, Level 16 Access to the remote server is denied because no login-mapping exists. A stricter connection validation check in the Database Engine can reject connections for certain linked server configurations that use the MSDASQL provider, even if earlier builds allowed those connections. For more information and workarounds, see Linked server queries that use MSDASQL fail with error 7416.
Other open issues in SQL Server
All known issues- Access violation when you query sys.dm_exec_requests during database recoveryOpen · SQL Server update known issues
- Access violation when you query sys.dm_exec_requests during database recoveryOpen · SQL Server update known issues
- Linked server queries that use MSDASQL fail with error 7416Open · SQL Server update known issues
- Linked server queries that use MSDASQL fail with error 7416Open · SQL Server update known issues
- Linked server queries that use MSDASQL fail with error 7416Open · SQL Server update known issues
- Linked server queries that use MSDASQL fail with error 7416Open · SQL Server update known issues
What changed
First observed 14 Oct 2026No field changes in the recorded history.
Cite this recorded revision to keep the same title, summary, facts and links when the page changes.
A day selects the latest observation by the end of that UTC day; today's selection can change until midnight. History starts when this installation records it.
Keep track
- Watch above puts it on My radar, which shows when the publisher changes it.
- SQL Server RSS feed: new known issues, releases and retirements.
- All open known issues across Windows, Office, Graph and Windows 365.