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