How to connect Azure Active Directory Interactive using MFA?

[peterbud]

What is the way to connect to Azure SQL database using MFA? I have tried to specify in the connection string AUTHENTICATION = ActiveDirectoryInteractive similar to the bcp tool but it's not working.

[ludovicasa]

Hello,
I have the same issue (version 1.0.0a23) with the following stack trace:

Scripting request: e9318ad9-e947-4aa7-9c1a-78d1f483dbf2 encountered error: Error parsing ScriptingParams.ConnectionString property.
Error details: System.ArgumentException: Error parsing ScriptingParams.ConnectionString property. ---> System.ArgumentException: Keyword not supported: 'authentication'.

   at System.Data.SqlClient.SqlConnectionStringBuilder.GetIndex(String keyword)

   at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value)

   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)

   at Microsoft.SqlTools.ServiceLayer.Scripting.SmoScriptingOperation.ValidateScriptDatabaseParams() in D:\repos\sqltoolsservice\src\Microsoft.SqlTools.ServiceLayer\Scripting\SmoScriptingOperation.cs:line 102

   --- End of inner exception stack trace ---

   at Microsoft.SqlTools.ServiceLayer.Scripting.SmoScriptingOperation.ValidateScriptDatabaseParams() in D:\repos\sqltoolsservice\src\Microsoft.SqlTools.ServiceLayer\Scripting\SmoScriptingOperation.cs:line 106

   at Microsoft.SqlTools.ServiceLayer.Scripting.ScriptingScriptOperation.Execute() in D:\repos\sqltoolsservice\src\Microsoft.SqlTools.ServiceLayer\Scripting\ScriptingScriptOperation.cs:line 42

[bolyardwork]

Same as above AAD auth should be supported