Azure SQL Authentication connection string in Azure App Service?

Question

Microsoft allows use of the Authentication command in Azure SQL to connect to the database using an Azure AD account.

https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/

Under heading 7.1. Connecting using integrated (Windows) authentication

How can I use this on an Azure App Service?

Note: I am specifically trying NOT to include the password as the next heading shows. I specifically want integrated.

Chris Gillum · Accepted Answer · 2016-02-23 19:17:18Z

1

If my understanding of the documentation is correct, you can achieve this yourself using Token Based authentication. It shouldn't require anything special from Azure App Service. See here for details and sample code:

https://blogs.msdn.microsoft.com/sqlsecurity/2016/02/09/token-based-authentication-support-for-azure-sql-db-using-azure-ad-auth/

The new token-based authentication method allows middle-tier services to obtain a token from Azure AD and use it to connect to Azure SQL Database.

answered Feb 23, 2016 at 19:17

Chris Gillum

15.1k5 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Goodwin Over a year ago

Sounds like what I wanted does not yet exist. I will try this as an alternative. Thanks.

Erik Oppedijk · Accepted Answer · 2016-02-23 19:31:18Z

0

Azure App Service machines are not part of your domain, so this isn't going to work. This was designed to let domain joined clients connect to SQL.

SQL Username/password is the only option left.

Update: see Chris Post about the new token based features

edited Feb 23, 2016 at 19:31

answered Feb 22, 2016 at 7:46

Erik Oppedijk

3,5484 gold badges33 silver badges43 bronze badges

2 Comments

Chris Gillum Over a year ago

I don't think this is accurate. Per the documentation, middle tier applications are able to connect to a SQL Azure database using token authentication. You might be confusing the domain-join requirement for using SQL Server Management Studio to connect using AAD credentials.

Erik Oppedijk Over a year ago

@ChrisGillum, You are right, according to the newly released feature you mention. Didn't know that yet (and wasn't it the link of the question)

Collectives™ on Stack Overflow

Azure SQL Authentication connection string in Azure App Service?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related