I'm able to launch SQL Server Management Studio (2014) from command line using something like below.

ssms.exe -E -S myservername -D -mydatabasename 

However, I'm not sure how to pass additional connection parameters such as multisubnetfailover=true

Is it possible to do this via commandline or through 'Target' on SSMS windows desktop properties?


1 Answer 1


Unfortunately not. If you type ssms.exe -? or look at the documentation you'll see the list of possible options:

[scriptfile] [projectfile] [solutionfile]
[-S servername] [-d databasename] [-U username] [-P password]
[-E] [-nosplash] [-log [filename]?] [-?]

So there is no option to specify a connection string or additional connection properties.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.