大网数据广告活动
数据库与应用安全

Troubleshoot MSDASQL linked server fails with error 7416

· 52CE 我爱测

MSDASQL linked server queries fail and generate error 7416 after a SQL Server CU or GDR update. Apply these workarounds to restore access.

Applies to:

  • SQL Server 2025 CU and GDR updates since April 2026
  • SQL Server 2022 CU and GDR updates since March 2026
  • SQL Server 2019 CU and GDR updates since April 2026
  • SQL Server 2017 CU and GDR updates since April 2026
  • SQL Server 2016 SP3 and Azure Connect Pack GDR updates since April 2026
  • Azure SQL Managed Instance

Summary

This article describes a known issue in which linked server queries that use the MSDASQL (OLE DB Provider for ODBC Drivers) provider and specify a provider string fail and generate error 7416. The article also provides workarounds that restore linked server connectivity without rolling back the update.

Symptoms

Linked server queries that use the MSDASQL provider and specify a provider string (@provstr) fail and return the following error message when a user that isn't a member of the sysadmin fixed server role runs the query:

Msg 7416, Level 16
Access to the remote server is denied because no login-mapping exists.

The failure can occur even if the linked server and login mappings are configured correctly.

Cause

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.

Workaround

To work around this issue without rolling back the update, use one of the following methods:

  • If your configuration doesn't require the provider string (@provstr), remove it from the linked server definition.
  • Add a User ID entry to the provider string (@provstr). For example, set User ID=<value>. The provider string must still include UID as well.

You can also prevent the failure by granting sysadmin permissions to the affected user. However, we don't recommend that you use this method.

October 2026 GDR update

Starting with the October 2026 GDR update, this issue is addressed. If you already applied a workaround from this article, the update continues to respect it.

Security considerations

As a security best practice, review access to MSDASQL linked servers and their associated data sources. Configure access for the users and workloads that need it, use least-privilege permissions, and periodically review authentication settings and access controls to help prevent unintended access.

Related content

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/14/2026
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。