I have run into issues several times when I have had Remote Desktop Sessions (RDP) open to servers and my computer has had to reboot unexpectedly (either because of WSUS updates or because it has hung) and RDP won’t let me get to my existing session, it just creates a new one when I go to login.  This uses both available administrative RDP sessions on the server (see picture below) and makes it inaccessible to anyone else trying to access it through RDP, as well as keeping me from getting to the work I had in process in the previous session and any windows that I had open.

rdp_img1

So, in the case of this example, I already had an RDP connection established to CORPI at the time my computer rebooted (ID #1).  When my computer came back up, I went to login via RDP to CORPI and it created another session (ID #2).

After much research, I found a way that Windows will let you access an RDP session that you have already established.  It is a command run from the command line on the server, so you would go ahead and login as Session ID #2 and once logged in, do the following:

  1.  Click Start, Run and type in “cmd” to get to a command prompt

 rdp_img2

  1. At the command prompt, type in the following command, tscon 1 /v
    1. The tscon command is the Terminal Services connection command.
    2. The argument, 1, is the Session ID.  This should be changed to whatever Session ID that you want to connect to.  In this case, it was Session ID #1.
    3. The /v parameter tells the tscon command to display information about the commands that are being performed.

Once you hit enter, your current connection to the server will be disconnected (in the case of my example, above, that would be Session ID #2) and you are immediately reconnected to the Session ID# that you specified in the tscon command.

Once you hit enter, your current connection to the server will be disconnected (in the case of my example, above, that would be Session ID #2) and you are immediately reconnected to the Session ID# that you specified in the tscon command.

 

I was also going to add that if you want to RDP to a server and both connections are in use, you connect by typing the server name followed by a space /admin and connect to the console session.

Getting started

11 May 2009
Any stalkers out there better watch out!

Any stalkers out there better watch out!

I was in the car a couple of weeks ago and the Beach Boys song “All Summer Long” came on.  The first verse is “Sittin in my car outside your house” – inspiring my 11 year old son to ask “Is this a song about a stalker?”.  That got me thinking about how much things have changed over the last couple of decades.

It used to be that you learned a skill, found a job and then used those skills to work until you retired.  That’s not the case now.  According to a Department of Labor study , people born in the later baby boom years have an average of 10.8 jobs between the ages of 18-42.  That breaks down to folks putting themselves out into the job market about every 2 1/2 years.  Doing that means keeping your skills up to date and relevant.

This is especially vital in the IT world.  If this is the profession that you choose – then you’ve set yourself up for a lifetime of learning.  As DBAs, we’re fortunate in that we have so many different sources to learn from.  Blogs, forums, newsletters, Twitter, etc. provide more information than any normal person could assimilate.

And that brings us to our blog.  Our hope is that we’ll be able to provide some useful information, bad humor or some combination of the two to other DBAs.   Enjoy and we’ll see you soon

 | Posted by tledwards | Categories: Miscellaneous | Tagged: , , , , |