CODEWITHSUNDEEP
azure-active-directoryazure-sql-databaseazure-functions
suresh
suresh

Reputation: 489

Keyword not supported: 'authentication'. for Azure Sql Sever connection string

Returns error 'Keyword not supported: 'authentication'' while trying to create a context using EF Core

"Data Source=tcp:XXXXXXX.windows.net,1433;Initial Catalog=XXXXX;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication=Active Directory Integrated"

Upvotes: 2

Views: 7006

Answers (2)

Ketan
Ketan

Reputation: 1550

Azure Functions V2 builts on top of .Net Core and AFAIK SqlClient for .NET Core still does not support using the 'Authentication' keyword in the connection string. That should work when this issue is actually fixed.

Upvotes: 2

Leon Yue
Leon Yue

Reputation: 16401

You can reference this bob: Azure Active Directory Connection String.

It has the same error with you. And the answer gives two suggestions:

  1. Have you been through this troubleshooting guide: Use Azure Active Directory Authentication for authentication with SQL.

  2. do you have .NET Framework 4.6 or later installed?

Follow this two suggestions, the problem is solved. I think you can try it and maybe it can helps you.

Hope this helps.

Upvotes: 0

Related Questions