SQL Server – Managing huge number of Server connections

My daily work involves connecting to several number of database servers and this involves me to remember server name or IP, port number, User Id and Passwords of those servers.  Number of servers I connect is more than 20 and due to this huge number I tend to forget the IP address, password etc. I can use the option of remember password, which will remember and list all the required server details with user id and password.

But the problem starts once you need to connect to a particular database server using more than one User Id. Once you use 2nd user id, SQL Server Management Studio fails to remember any of the passwords for that server.

So what is the solution?

SQL Server Management Studio has an option to manage server details, i.e. Registered Servers. By registering the server connection in the Registered Servers component of SQL Server Management Studio you can save the connection information for servers that are accessed frequently.
This option can be found under View menu.

A separate window will appear on the left hand side of the SSMS along with Object explorer. On right-clicking on Local Server Groups, option to register new server or to create new server group will appear. Creating Server group is optional but it will help in managing large number of server connections by logical grouping.

When Server Registration is opted, below window will appear. Opt for remember password option to remember the server connection.

In the above window you will find another tab which can be used to customize the connection further.

  1. Default database can be set here, so that every time you connect to a particular server from the registered server option, it will by default connect to the default database.
  2. Choose custom color for each server connections, so that one can easily differentiate between each connection.

About these ads

About Krishnaraj Barvathaya

I am Krishnaraj Barvathaya, a software developer from Bangalore and I primarily write on Microsoft Technologies and latest technical stuffs which interests me.

Posted on May 10, 2012, in .Net, SQL Server and tagged , , , . Bookmark the permalink. 3 Comments.

  1. Neat. How about if you change machines? Will you be able export connection configuration? Or will you have to do this across all machines you use?

    • Thank you Mahesh. One can export registered server information along with the saved user Id and password (optional) as .regsrvr file. This can be imported in any other instance of SQL Server [Local Server Groups->(Right Click)->Tasks->Export].

  2. Write more, thats all I hqve to say. Literally, it seems
    as though you relied onn the video to maake your point.

    You definitely know what youre talking about, why throw away your intelligence on just posting videos to your site
    when you could be giving uus something informative to read?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 123 other followers

%d bloggers like this: