This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(80, 84%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
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
![](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(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
@Patel, Hitesh Thank you for reaching out.
Please post the error message so that we can troubleshoot further.
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