Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

connect to a server Expand / Collapse
Author
Message
Posted Tuesday, September 8, 2009 9:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:20 AM
Points: 432, Visits: 1,073
if i trying to connect to a server then i get the error message as "The terminal server has exceeded the maximum number of connections."

so how will i conect.
Post #784337
Posted Tuesday, September 8, 2009 9:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:56 AM
Points: 2,699, Visits: 1,144
charipg (9/8/2009)
if i trying to connect to a server then i get the error message as "The terminal server has exceeded the maximum number of connections."

so how will i conect.


normally there are only 2 connections to the server. you can ask who is on the server currently to come off it. or you can use a console session. However you would need to be a local server admin to be able to do that.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #784342
Posted Tuesday, September 8, 2009 9:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 9, 2011 7:24 AM
Points: 87, Visits: 392
As I`m a betting man I`ll guess that people have been logging off RDP incorrectly - it always happens.

Console is you friend here as already mentioned. Add a /console to the RDP shortcut - or /admin depending on the version (I think).
Post #784346
Posted Tuesday, September 8, 2009 10:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 31, 2014 12:26 PM
Points: 60, Visits: 252
if u want use Remote desktop u can use this :
mstsc -v [destination] -console
Post #784396
Posted Tuesday, September 8, 2009 10:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:56 AM
Points: 2,699, Visits: 1,144
farax_x (9/8/2009)
if u want use Remote desktop u can use this :
mstsc -v [destination] -console


Only if you are a local server admin, can you use console.

the alternative is to use terminal services manager from another server and change connection to that server and see who has the sessions open and kill the session if need be.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #784400
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse