search

microsoft / mssql-scripter

Repository for the new SQL cross-platform command line tools
Other
736 stars 142 forks source link

How to connect Azure Active Directory Interactive using MFA? #261

Open peterbud opened 2 years ago

peterbud commented 2 years ago

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 commented 11 months ago

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 commented 9 months ago

Same as above AAD auth should be supported