Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,972 questions
Command 'CREATE LOGIN FROM EXTERNAL PROVIDER' is not supported as Azure Active Directory is not configured for this instance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Rob Lewis
0
Reputation points
We have an SQL Server on an Azure VM.
For our main instance, which is our live one, Entra euthentication works without any problem. We can create and login directly using Entra authentication.
We also have another instance of SQL on the same server which we use as our test. When I try create and an entra id login on that, I get this error "Command 'CREATE LOGIN FROM EXTERNAL PROVIDER' is not supported as Azure Active Directory is not configured for this instance." I can't see anything in the azure portal that defines the Entra Id login by instance, only server.
How do I configure our second instance to also use Entra Id login?
Many thanks in advance
{count} votes
-
Erland Sommarskog 112.5K Reputation points MVP2024-10-16T21:17:50.5133333+00:00 From another thread, I recall that someone said that Azure integration that runs on Azure VMs only supports default instances. I have not come around to verify this, and I would like to believe that it is incorrect, because it sounds really bad.
Anyway, I believe that to create Entra logins you need to be logged in as an Entra administrator. That is, you first need to set up an Entra Administrator for the instance.
Sign in to comment
Sign in to answer