How to drop unused connections on a Server

0 Comments | Rating: 0 | |

I had to connect to a server on which one of our applications was hosted and I was being kicked out of the system saying "The terminal server has exceeded the maximum number of allowed connections.". I had to figure out some way to login to this system as there was no one so cooperative as to help me out of this situation. I started struggling.... 1 hr and then I find the solution. Well to be informative for everyone in nice and easy steps, I give the following

1) Go to command prompt on another server with Windows 2003 or like OS and type the following on command prompt

query session /server: servername

This will give you the a few fields along with the Session ID, type of connection, User name etc...

For servername, give the name of the server you want to find out who is logged in to. You will be given a list of users

2) If you suspect that someone is not using the system and has left the connection hanging there, you can type the following and drop their connections( only after confirming they are not using )

reset session ID /server: servername

For the parameter ID give the ID of the User that you want to drop. The ID is gotten from the previous command. You can drop all connections of just one to accomodate you.

This is good than having to reboot.