用户'NT AUTHORITY \ ANONYMOUS LOGON'登录失败。 - MSI（管理身份） [英] Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - MSI ( managed identity )

问题描述

我已经关注 

我已登录我的Azure帐户  'Azure
服务身份验证' 扩展。但是，我仍然收到错误。

其他详细信息：

• 
  Visual Studio 2019社区 - 版本16.1.0预览版3.0
• 
  .NET Core 2.2

---

问候，Hemant Shelar

解决方案

Hello Hemant，

您使用自己的身份证登录Visual Studio。

是否在AD租户中创建了与工作帐户关联的数据库？ 

哪个帐户被设置为SQL服务器的AD管理员？ 

如果您以[e-mail]身份登录Visual Studio，则需要先在数据库中创建此用户并授予相应的权限。

或者， 您还可以将用户添加到您配置访问的同一个AAD组。

在您在问题中引用的文章末尾，有一个

部分，其中说明了如何设置AD组并配置组以便在数据库中进行访问。

如果您有任何疑问，请告诉我们。

-



如果以上答案有帮助，单击"标记为答案"或"向上投票"，这可能对阅读此主题的其他社区成员有益。 

I have followed this tutorial to secure Azure SQL Database connection from App Service using a managed identity.

Everything is working as expected in Azure, but when I am trying to debug the code locally I am getting below error message while opening the connection.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I found few references where they have mentioned we can use 'Azure Service Authentication' extension to debug locally.

I have logged into my Azure account in 'Azure Service Authentication' extension. But, still I am getting the error.

Other Details:

• Visual Studio 2019 Community - Version 16.1.0 Preview 3.0
• .NET Core 2.2

---

Regards, Hemant Shelar

解决方案

Hello Hemant ,

You are signed in to Visual studio using your Live ID.

Is the database created in an AD tenant associated to a work account? 

Which account is set as the AD Admin for the SQL server? 

If you are logged in to Visual Studio as [e-mail], you will need to create this user on the database first and grant appropriate privileges.

Alternatively, You can also add the user to the same AAD group that you provisioned access to.

Towards the end of the article that you referenced in your question, there is a section that explains setting up an AD group and provisioning the group for access in your database.

Please let us know if you have any questions.

-

If the above answers were helpful, click "Mark as Answer" or "Up-Vote", which might be beneficial to other community members reading this thread. 

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