Make Central Management Server remember Azure Integrated authentication for Azure SQL DB
In SSMS 17.8.1 we have a number of Azure SQL DB instances registered in our CMS.
Everytime we re-open SSMS the CMS switches the authentication method back to "Windows Authentication"
Manually switching back to "Azure - Integrated" works, but this option should be persisted and remembered in the CMS.
Mark Timson commented
Love how this is 2 years old and Microsoft haven't even gave it a second look. This needs to happen. The list system table just needs something to remember auth type.
This needs to happen the same is true for Azure Data Studio. It passes MFA auth when it should pass integrated. There is no way to set this from what I can see in the [sysmanagement_shared_registered_servers_internal] Table.
MS - Please implement this.
Completely agree. Every time SSMS is restarted you have to change the authentication method, even though SSMS has the option to save your choice.