Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can connect SQL Server Management Studio to a SQL DB by passing command line parameters like this:

"C:\Program Files (x86)\....\Ssms.exe" -E -S SERVERNAME -d DB_NAME -nosplash

(Obviously -E is for window Authentication)

This connects to the SQL Server. But I often find I want to connect to an Analysis Server instance instead. Can anyone tell me the command line option please?

share|improve this question
up vote 1 down vote accepted

There isn't one.

SSMS command-line options help screen

But... why open and close Management Studio all the time? Leave it open and use the Registered Servers list (View | Registered Servers).

share|improve this answer
In my work I login to multiple clients over the course of a day and have to log in and out. – Preet Sangha Oct 26 '12 at 2:03
@PreetSangha: So for each client you would need to set up a shortcut... why not set up Registered Servers instead? You'll undoubtedly need access to other servers as well. – Jon Seigel Oct 26 '12 at 2:21
Will look into it. Will registered servers give me the full break down of objects like sps, tables etc? – Preet Sangha Oct 26 '12 at 2:52
@PreetSangha: Registered Servers is just a saved, organized list of servers: it makes connecting to servers easier (less typing). You can also use it to leverage multi-server queries and Policy-Based Management over server infrastructure. – Jon Seigel Oct 26 '12 at 2:59
Thank you - I think is a fine compromise. – Preet Sangha Oct 26 '12 at 3:02

I don't know of a parameter which will make that happen. None of the documented parameters will tell it to switch to another instance type.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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