Add-on Manager: Is it possible to manage different Versions of SSMS

Add-on Manager: Is it possible to manage different Versions of SSMS

avatar

Hello
Is it possible to manage 2 SSMS version with the add-on manager?
We use SSMS 17.x for connections with -P but also need SSMS 18.x for databases in Azure.

I want to keep SSMS 17.x as default, but when I need to connect to a managed instance in Azure RDM should start SSMS 18.x instead 17.x

Regards
Martin

All Comments (5)

avatar

Hello,

For now I don't think we can support this. However, you could use the Command Line Entry type, and use the SSMS command line arguments :
SSMS [-S servername] [-D databasename] [-G] [-U username] [-E] [-nosplash]
More detail about SSMS Command line https://docs.microsoft.com/en-us/sql/ssms/ssms-utility?view=sql-server-ver15
I would use this one for SSMS 18, since the 17 still supports the password...

Otherwise, you can always file in a Feature Request here : https://forum.devolutions.net/forums/17/remote-desktop-manager--feature-request

I hope this helps!

Best regards,

Alex Belisle

avatar

Hi Alexander

Thanks for the reply, I have created a feature request and use the SSMS Command line as a workaround

Regards Martin

avatar

Hello

Awesome, thanks for the feedback.

Best regards,

Alex Belisle

avatar

Hi Martin,

I turns out there is a little-known feature (that is somewhat buggy) that will work for you. It's not perfect but until we get the feature fixed it can do the job.

  1. RDM File > Options > Path > SQL Server Management Studio
    1. enter both of the ssms.exe executable files paths, separated by ';'
      1. In my case it looks like this (v18 & v17):
        1. C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio
  2. Now start your SSMS session
  3. You will be prompted with a dialog asking you to select the ssms path, double-click it.
    1. Note: you will get prompted 3 times, sorry it's a bug.
  4. This will start ssms session with the selected version.


forum image
forum image

Stéfane Lavergne

avatar

Hi Stéfane

Excellent, that will help a lot for now.
It would be great if you could configure aliases for the installation paths so that these are displayed in the selector instead of the paths

Regards
Martin

Ends in 13 days