用户'NT AUTHORITY \ ANONYMOUS LOGON'登录失败 [英] Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

问题描述

我收到间歇性错误消息  用户'NT AUTHORITY \ANONYMOUS LOGON'
登录失败，同时从web应用程序连接azure sql db。我正在使用SQL AAD身份验证。我已经向用户提供了所有必要的许可。

请在这里帮助我。

解决方案

您好，

当AAD用户尝试连接到master数据库但没有master中的用户时，会发生此错误。要解决此问题，
要么指定要在连接时连接的SQL数据仓库，要么将用户添加到主数据库

请检查这些链接是否存在类似问题 -

https： //docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-troubleshoot

https://social.msdn.microsoft.com/Forums/azure/en-US/33e073f1-29d5-4bc7-83d7-7c2075ed817b/trouble-to-access-azure-sql-database-with- microsoft-sql-server-management-studio？forum = ssdsgetstarted

Reg ards

Kapil

Hi,

I am getting intermittent error message Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' while connecting azure sql db from web app. I am using SQL AAD authentication. I have given all necessary permission to user.

Please help me here.

解决方案

Hello,

This error occurs when an AAD user tries to connect to the master database, but does not have a user in master. To correct this issue, either specify the SQL Data Warehouse you wish to connect to at connection time or add the user to the master database

Please check these links for similar issues -

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-troubleshoot

https://social.msdn.microsoft.com/Forums/azure/en-US/33e073f1-29d5-4bc7-83d7-7c2075ed817b/trouble-to-access-azure-sql-database-with-microsoft-sql-server-management-studio?forum=ssdsgetstarted

Regards

Kapil

这篇关于用户'NT AUTHORITY \ ANONYMOUS LOGON'登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！