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

1
votes

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"

2
azure-active-directoryazure-sql-databaseazure-functions
Try setting up the connection string for the database in the Function App application settings like this: Data Source=<server>.database.windows.net;Initial Catalog=<database>; azurecorner.com/… docs.microsoft.com/en-us/azure/app-service/… – Ketan
I tried your suggestion and getting this error. 110003;Invalid user or password – suresh
Please refer to this thread stackoverflow.com/questions/45597736/… – Alberto Morillo

2 Answers

1
votes

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.

0
votes

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.