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

Question

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"

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/… learn.microsoft.com/en-us/azure/app-service/… — Ketan
– Ketan, Commented Mar 7, 2019 at 11:46
I tried your suggestion and getting this error. 110003;Invalid user or password — suresh
– suresh, Commented Mar 7, 2019 at 11:55
Please refer to this thread stackoverflow.com/questions/45597736/… — Alberto Morillo
– Alberto Morillo, Commented Mar 7, 2019 at 14:48

Ketan · Accepted Answer · 2019-03-15 13:45:58Z

2

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.

answered Mar 15, 2019 at 13:45

Ketan

1,58010 silver badges16 bronze badges

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

Comments

Leon Yue · Accepted Answer · 2019-03-08 02:03:13Z

0

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

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

Have you been through this troubleshooting guide: Use Azure Active Directory Authentication for authentication with SQL.
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.

answered Mar 8, 2019 at 2:03

Leon Yue

16.5k1 gold badge17 silver badges26 bronze badges

1 Comment

Jon Over a year ago

Does github.com/dotnet/SqlClient now support the 'Authentication' keyword for AD?

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related