Open dayport opened 6 years ago
Unfortunately, mssql-scripter does not support active directory password. This is a limitation of the Microsoft/sqltoolsservice which is used by mssql-scripter. We are investigating adding support, however I don't have any timelines currently that I can share for this feature.
The underlying sqlclient driver issue for AAD auth https://github.com/dotnet/corefx/issues/8807
Hi. The original issue https://github.com/dotnet/corefx/issues/8807 has been resolved. Is it possible to use AD auth in mssql-scripter ?
Thanks
Any news on this?
mssql-scripter --connection-string 'Server=,1433;Initial Catalog=;Persist Security Info=False;User ID=;Password=;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Password";'
Results in the following error: 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.ScriptingScriptOperation.ValidateScriptDatabaseParams() in D:\repos\sqltoolsservice\src\Microsoft.SqlTools.ServiceLayer\Scripting\ScriptingScriptOperation.cs:line 335 --- End of inner exception stack trace --- at Microsoft.SqlTools.ServiceLayer.Scripting.ScriptingScriptOperation.ValidateScriptDatabaseParams() in D:\repos\sqltoolsservice\src\Microsoft.SqlTools.ServiceLayer\Scripting\ScriptingScriptOperation.cs:line 339 at Microsoft.SqlTools.ServiceLayer.Scripting.ScriptingScriptOperation.Execute() in D:\repos\sqltoolsservice\src\Microsoft.SqlTools.ServiceLayer\Scripting\ScriptingScriptOperation.cs:line 72