Azure SQL / Azure AD Authentication support for SQL Server Management Studio Add-On

What is missing? We just invoke the command line. Do you know if we can add something to the command line?

Regards

Hi David

Thanks for your quick reply.

Here is some overall information from Microsoft on the new features of SSMS 17.3
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-ssms-mfa-authentication

Here are some connection string examples, which I guess could be used int he command line fro SSMS

(Active Directory password authentication)
Server=tcp:mydbsrv.database.windows.net,1433;Initial Catalog=mydatabase;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Password"

(Active Directory integrated authentication)
Server=tcp:mydbsrv.database.windows.net,1433;Initial Catalog=mydb;Persist Security Info=False;User ID={your_username};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Integrated"

I have not been able to guess how to pass connection strings to SSMS via command line.

I will reach out to Azure support right now to get an explanation as to why the ssms.exe cli switches for Authentication have not been updated.

Thank you very much

SQL Support at MS has confirmed that this has not been implemented in the command line yet.
They are investigating when it will be implemented.

I asked them to investigate if there is any other way to supply the credentials to the application in an automated fashion.

Will let you know once I have the update. thanks again for a great product and support.

UPDATE: Seems there was no plan to include this, however, in light of my request, they asked the product team to look into it, and they were positive about adding it to the command line.

Right now I am waiting to hear if they will put it into their short or longterm plans, so we might have to wait a few months before this will be possible with the newest release of SSMS.EXE

UPDATE:


The Request has been approved by Microsoft, and they are aiming at having commandline support for Ssms.exe to connect to Azure SQL with Integrated authentication by the end of this year.
However delays might occur..

Michael,

Nice. Is this feature request via a public user voice or something like it? Do you have a link to the request? I would like to register to get notifications.

Best regards,

I requested it through enterprise support, so I get personal bi-weekly updates.
I will be sure to post them here asap :)

FINALLY!


I received info from the team tha the feature has been implemented and release with the newest version of SSMS :)
Added a new command line option ("-G") that can be used to automatically have SSMS connect to a server/database using Active Directory Authentication (either 'Integrated' or 'Password'). For details, see Ssms utility.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Hope you can implement the new authentication mechanisms in the add-on :)


Thanks.

Nice,
I will add this to our todo list.

Regards