Share via

Windows authentication with sql mi

Biju Mathew 481 Reputation points
2021-05-03T13:59:28.17+00:00

Hi
Our existing application connects to sql server on prem db using SQL authentication. We are migrating the app and db into azure.
The database will be moved into sql mi. Our application here is a middleware application-it’s not like a website where a user logs in .
We have been asked to change the sql authentication mode as part of the security changes to move to cloud.
What are our options here?
Is windows authentication possible for the application such as this? My understanding of windows authentication is it is to be used in scenarios where a user logs into windows and then uses a tool like ssms to connect to sql server. Not sure how will this work for a middle ware app like ours.

Looking for some guidance here please

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator
    2021-05-04T02:24:55.97+00:00

    @Biju Mathew

    Windows Authentication is not available for Azure SQL or Azure SQL Managed instance. More feature comparison here.

    The Authentication available are SQL Authentication or Azure AD authentication. More info here.

    Regards
    Navtej S

    1 person found this answer helpful.
  2. Niko Neugebauer 1 Reputation point Microsoft Employee
    2022-02-08T14:34:41.88+00:00

    At Ignite 2021 Fall in the early November, we have announced this as a feature for SQL Managed Instance in the limited public preview and so it is on a good path to General Availability as of early February of 2022:

    https://techcommunity.microsoft.com/t5/azure-sql-blog/make-your-azure-sql-managed-instance-passwordless/ba-p/2908166

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.