Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm running a server with 3 database instances.
Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else).

Would it be possible to have it so that, when I open it, it's already connected to these 3 instances, so I can start working right away and save a few clicks? It'd save me hundreds of clicks a day, honestly.

This would be equivalent to what we had in SQL 2000 Enterprise Manager, where you could "register" servers, and they'd always be there just a click away.

EDIT: To clarify what I'm looking for... Before we had Enterprise Manager and Query Analyzer. Now SSMS is the blend between those two, but the "connection" part works exactly like Query Analyzer.
What I do every day is open SSMS to manage the DBs, check their stats, rebuild an index here and there, I'm not using it to run that many queries, so I'm looking for a way to have the SQL instances available on the Object Explorer automatically when logging in. Is this impossible now? :-(

share|improve this question
    
It would be nice if Microsoft provided a fix for this issue. SQL 2000 Enterprise Manager is definitely more user-friendly in this regard. –  mg1075 Jun 13 '11 at 17:03
    
seems to be an open bug quite a while: connect.microsoft.com/SQLServer/feedback/details/155855/… –  ralf.w. Sep 2 '11 at 6:40

5 Answers 5

up vote 5 down vote accepted

I just discovered it this evening, so let me share my joy: Registered Servers are still available in SQL Server Management Studio!

In the View menu, choose Registered Servers. That will open the window for them. Then, drag that window to the side to dock it.

Along the top of the window you'll see icons for the types of servers (SQL, SSAS, SSIS, SSRS). Choose the type you're registering.

Add your instances to the Local Server Groups by right-clicking and selecting New Server Registration, then complete configuration for the connection.

Once that's done, you can double-click on a server to open the Object Explorer for that server.

share|improve this answer
1  
Yeah, I had found this... It's not ideal, though, because using this takes about as many clicks as using the login dialog. :-( I think I'll have to use this anyway... –  Daniel Magliola Jul 24 '09 at 14:10
    
@DanielMagliola you can right-click the groups as well and connect to all servers in it, see my answer for more details. –  Valentino Vranken Nov 27 '12 at 12:16

OK, so this is what I did (I'd like to edit the accepted answer because I based this on his idea, but I don't have enough points...)

  1. I set SSMS to start with "an empty environment", so it doesn't prompt me for a login (Tools-> Options->Environment->General).
  2. I opened Object Explorer and docked it to the left
  3. I opened Registered Servers and made it a "Tabbed Document" instead of a "Dockable" window. 4). In the middle pane, I opened Registered Servers and Object Explorer Details, which SSMS apparently remembers from session to session.

So now when I get in, I have the list of my servers right there and I can connect with a few clicks. It's not perfect, but it's close enough that i'll stop fighting it :-)

Thank you sphilp!

share|improve this answer
    
Do you know how to make the "Local Server Groups" stay expanded. Everytime I open SSMS, the "Database Engine" list of registered servers is always collapsed. –  Brian Chavez Jul 5 '13 at 1:53
    
This is great!! –  enderland Aug 29 '13 at 21:10

I tried adding additional info to the answer by sphilp but that edit got rejected because some people seem to think it's incorrect. I can assure you: it is not.

What I wanted to add:

The Registered Servers functionality in SSMS can be used to connect to several servers in just a couple of clicks. If you group the servers together by creating a New Server Group under the Local Server Groups node, you'll be able to right-click that group and select Object Explorer. This will open all servers in ... Object Explorer!

More details: SSMS: Connect To Several Servers In One Click (Okay, Two)

You can even influence the order in which the connections are opened (alphabetically).

share|improve this answer

About the best you can automatically do is this:

  1. Select Options from the Tools menu
  2. Under Environment, select General
  3. In the At Startup drop-down select Open Object Explorer and click OK

It's not exactly what you want, but it'll give you a login prompt of what server to connect to and then open up with Object Explorer connected to that server. You will, though, only have a connection in Object Explorer to a single server...

share|improve this answer

Here you will find information on how to start the SQL Server Management Studio (SSMS) from a shortcut or from the command line.

The following will open the SSMS by using Windows Authentication and will bypass the splash screen. The query editor will be set to the SMS_XXX database:

SqlWb -E -S SQLServerName -d SMS_XXX –NoSplash

Note: Change SQLServerName as needed.

SqlWb Arguments:

SqlWb (Options) Scriptfile Specifies one or more script files to open. Projectfile Specifies a script project to open. Solutionfile Specifies a solution to open.

-S Server Name -d Database Name -U Username -P Password -E Windows Authentication -Nosplash Bypasses the splash screen -? Help

Referenced from: http://myitforum.com/cs2/blogs/dhite/archive/2008/05/26/opening-the-sql-server-management-studio-from-the-command-line.aspx

I don't think you will be able to automate the 3 connections. But you could create linked servers so that you connect to 1 and link to the other 2

share|improve this answer
1  
Hmmmm, the main problem I have with this approach is that it does connect, but not in Object Explorer which is what I use every day... –  Daniel Magliola Jul 24 '09 at 14:09
    
@DanielMagliola Alt-F8 will refresh the Object Explorer to the current Server. Not the current database, though this answer points to a solution that does: stackoverflow.com/questions/12172446/… –  Jeroen Wiert Pluimers Apr 3 '13 at 15:23

Your Answer

 
discard

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.