The terminal server has exceeded the maximum number of allowed connections - Solution

When trying to take a Remote desktop on Windows Servers, got the error message "The terminal server has exceeded the maximum number of allowed connections".

Root Cause: 
This is because, Windows 2003 Server supports only two active RDP connections. When you try as third, you may experience this issue. Ideally, user must "Log Off" to end-up the session rather disconnect.

Just closing the remote desktop window disconnects the user but it keeps the session active. Next time when user tries to login,  he gets the error message.

Solution:
Alright, what is the workaround to by pass this error and login to Windows Server 2003 or Windows Server 2008? Go to command line, or Run dialog box. If you are running remote desktop from Windows Server 2003 or Windows XP, enter: MSTSC /v: <MachineName or IP> /f -console

E.g. MSTSC /v:SPSrv01 /f -console

For Windows 2008/Windows 7, use: mstsc /v:SPSrv01 /f /admin

Now, you should be able to login to the server and logoff disconnected user sessions from Task Manager. For some reason, if the above methods didn't work, use the alternate: force log-off uses sessions. Here is how:

1. Query the active user sessions to find who is logged in: query session /server:servername
2. Terminate the user session by: Reset session [Session ID] /server:servername

This kills the session.