用户'NT AUTHORITY / ANONYMOUS LOGIN'的Azure SQL服务器登录失败 [英] Azure SQL server Login failed for user 'NT AUTHORITY/ANONYMOUS LOGIN'

问题描述

我正在尝试使用我的Azure活动目录帐户从SSMS登录到Azure SQL服务器。
我遵循了此指南：

我的帐户在SQL数据库的属性中也显示为Active Directory管理员：

然后，我尝试使用具有Active Directory身份验证的SSMS登录： $ b

我使用我的帐户登录并获得MFA通知，但此后出现以下错误：

欢迎使用任何技巧。

解决方案

您正在使用哪个SSMS版本？

如果您使用的是SSMS 17.9，请尝试指定数据库名称并在 Options -> 连接属性。

恭喜您，此问题已解决。

希望这会有所帮助。

I'm trying to log into an Azure SQL server from SSMS using my Azure active directory account. I've followed this guide: Configure and manage Azure Active Directory authentication with SQL

I've added my account as an admin:

And my account also shows up as the Active Directory admin in the properties of the SQL database:

Then, I try to log in with SSMS, with Active Directory authentication:

I login with my account and get the MFA notification, but after that I get the following error:

Any tips are welcome.

解决方案

Which SSMS version you are using?

If you are using SSMS 17.9, try specifying the db name and set AD domain in Options -> Connection Properties.

Congratulations that the error have be solved by this.

Hope this helps.

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