question

NikosDrakopoulos-3854 avatar image
0 Votes"
NikosDrakopoulos-3854 asked MasoodAhmadMohammedIshaq-3516 answered

Connecting to "SQL Server on Azure VM" SQL instance through the internet, using "Active Directory - Password" authentication

Hi all,

I have a "SQL Server on Azure VM" on Azure, which is simply a Windows Server with preinstalled SQL server as far as I can tell.
I have created an "Azure AD Domain Services" domain, and joined the server successfully there, so user management is on Azure AD.

Now I'm trying to connect to the SQL server directly through the internet, by using an account on this directory. I can successfully logon to the server using an SQL user, so firewalls etc are configured correctly. I can also logon to the SQL instance locally from the server, so the permissions are also set properly.

But when trying to connect by using "Active Directory - Password" on either the SQL Management studio, or my .net application, I get error "Login failed for user ". (Microsoft SQL Server, error: 18456)

Please note that the above scenario works properly if I use either "Azure SQL Database" or "Azure SQL Managed Instance", after adding the user as an "Active Directory admin" in the Azure portal.

Am I missing something on the configuration of Azure AD? Or is this scenario just not supported?

Thanks in advance

azure-ad-domain-servicesazure-sql-virtual-machines
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This is an unsupported scenario . However theoretically it should work . There may be some custom configuration on the SQL side for logins which may allow only admins. If you try to use Active Directory - Password , the connection should be within the local network to the Azure AD domain services as it will use legacy auth, Kerberos which may not be possile unless port 88 , 464 , 135 and others are open from your SQL VM to the Azure AD domain services instance.

0 Votes 0 ·
RohithC-1867 avatar image
0 Votes"
RohithC-1867 answered

Hi,
Were you able to find the cause here ? i have the same issue

Regards,
Rohith

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MasoodAhmadMohammedIshaq-3516 avatar image
0 Votes"
MasoodAhmadMohammedIshaq-3516 answered

Hi
we are also looking for a solution to this scenario.


Regards
Masood

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.