CODEWITHSUNDEEP
sql-serverazureazure-sql-database
RSax
RSax

Reputation: 338

Azure SQL Server Cannot Be Accessed With Active Directory Authentication

My organization has an Azure tenant. The tenant has three subscriptions. Each subscription has multiple Azure SQL Servers. On two of the subscriptions, the databases can be accessed via one of the Active Directory authentication methods. On the third subscription, the only method of access is via SQL Server Authentication. I am the owner of this third subscription.

If I configure an Active Directory Admin for the Server, the error I receive is:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)

When I remove the Active Directory Admin for the Server, the error I receive is:

Requested tenant identifier '00000000-0000-0000-0000-000000000000' is not valid. Tenant identifiers may not be an empty GUID.

How do I change this so that the SQL Servers can be accessed via Active Directory authentication? What is the best approach to determine the the differences between the subscription at issue and the other two subscriptions?

Upvotes: 1

Views: 1186

Answers (1)

Sergei Koshel
Sergei Koshel

Reputation: 51

To solve this issue, you need to set Active Directory Admin for the SQL Server (Settings -> Active Directory Admin).

Upvotes: 2

Related Questions