sql - How to connect to the Azure DB if your connection string is not supporting the authentication keyword

Question

My connection string contains an authentication keyword whose value is Active Directory Password but when I am using it then my code is throwing an error. Is there any other way to establish the connection?

Answer 1

as I searched and find that, keyword "authentication" is not yet fully supported in .NET for now.

This extension is built on .Net Core, which didn't have support for Azure Active Directory authentication at all until recent prerelease versions. That is why the keyword error above is shown.

For more details, you could ref the Microsoft engineer's answer here:

1. Keyword not supported: 'authentication' error for azure integrated connection
2. https://github.com/Microsoft/vscode-mssql/issues/1159

HTH.