Click here to monitor SSC

Jonathan has been working with SQL Server since 1999. He enjoys performance tuning, development and using SQL Server to provide appropriate business solutions. He is the founder and leader of the PASS SQL South West user group http://www.sqlsouthwest.co.uk , is a moderator at SQL Q + A forum ask.sqlservercentral.com and is on twitter at @fatherjack. He has spoken at SQLBits and SQL in the City, SQL Saturdays and local user groups across the UK and Europe.

Getting hold of another PC

Published 7 October 2010 3:53 pm

Being able to access servers and PCs from where-ever you are can be a great bonus if you happen to be at all mobile in your job or don’t happen to live in your office. If you travel between locations then getting on any PC and being able to work on one somewhere else can save time and money, being able to get onto a work computer from your home PC can be a (personal) life saver.

Up until recently I have used Remote Desktop Connection found in Start | Programs | Accessories and have successfully entered an IP address or server name and worked on a desktop hosted on the remote computer. All of your familiar Windows environment is around you – mapped drives, printers, desktop, My document etc etc. Having a window open for each remote ‘session’ made working on multiple servers possible and with two monitors it was pretty efficient. Now, however, it has just become several hundred percent easier. I have found Remote Desktop connection Manager, downloadable (for free) from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=4603c621-6de7-4ccb-9f51-d53dc7e48047&displaylang=en. Downloading the 789kb file and going through the 5 clicks to install it is a very short journey to remote session clarity.

RDM_01Once installed you get to create Groups and then, inside those groups, servers. The one thing to note is that a server can only feature in one group, but groups can feature inside other groups.

 

 



 RDM_02

 

 

Now the hierarchy that you create can share settings, such as usernames, passwords etc This means that when your domain password changes you only need to change it once for the uppermost group and then which ever server you select will connect using those settings.

You can choose for a server to ‘opt out’ of this inheritance and use different credentials if you want it to.

 

RDM_03

Connecting to a server, once you have the parent settings configured is a simple double click, either on the node or in the grid view on the right.

 

 

 

RDM_04

… and at the end of the day, you can clear up all of your connections in one go simply by selecting the parent node and either disconnecting or logging off the whole group.

 

 

Brilliant!

Remote control was never so easy.

4 Responses to “Getting hold of another PC”

  1. Anonymous says:

    Totally agree with you, amazingly simple tool and a timesaver. Since early summer I have been enjoying RDCMan, and my colleagues are enjoying it now too.

    Make the mistake once of logging onto all forty servers at once by right-clicking and Connecting Group! Sort of felt like that moment in Batman Dark Knight when there was wall of screens and thousands of conversations going on…

  2. Anonymous says:

    Thanks Jonathan.
    I have been meaning to get RDCM for some time now (was also going to ger Royal TS) but have been putting it off until I read your blog this morning. I prefer to use SSMS rather than RDP (yes a verb and acronym like PING) but when I do, I make it DOS Equis. Yes, that is DOS not 2. Ok, now this has just gotten silly. Thanks for the prod…and dev and qa. silliness continues. Need more Java. Stop IT! Can’t do it.

  3. thensley says:

    Dude! Thank you! This is so much better than all the RDP files I had laying around.

  4. jmartin95 says:

    awesome…thank you

Leave a Reply