Azure SQL Managed Instance with a Web server on domain

Patel, Hitesh 1 Reputation point
2021-01-15T21:11:45+00:00

We are looking to switch out a vm with sql and instead use Azure managed SQL and have our web servers connect to them web servers are a VM in azure and are part of a domain

how can i have the web servers connect to the sql managed instance without having to enter the SA creds in the connection string we would like to use Active Directory or Active Directory Service Principal names but i cant seem to get it to work. thanks

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Martin Cairney 2,241 Reputation points
    2021-01-18T07:17:08.513+00:00

    Managed Instance currently only works with Azure Active Directory - not Active Directory.

    You will have to configure directory sync between your AD and Azure AD and then you can use the same principal names.

    See here

    0 comments No comments