SQL Server Performance Forum – Threads Archive
terminal server connections has exceededHi,
When I try to log on to server using remote desktop conection from the local system. It throws a error as "The terminal server has exceeded maximum number of allowed connections" How to trouble shoot this issue from local system? I know one option when you know the IP address of the server using
mstsc/v:00.00.00.00/console, but all the time one can’t remember the IP addresses, what’s the alternative method to solve this.
Thanks in Advance
You can ping the server by name to get the IP address… You have to have the permissions to disconnect your RDP connections… If you can acess the computer management of the computer which you want to connect through rdp, you can stop the RDP server… MohammedU.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Have you checked how many connections are configured for RDP?
If you can manage the connection to SQL tools then why do you need to logon using RDP or is this server located under DMZ (firewall)? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.