Admin connection

Hi every one, i am getting a problem as i was new to this DBA here when i was logging in to the server then i am getting the error Max terminal connections exceeded.then in am trying to connect through admin acces the syntax i am using is in Run command: <mstsc \\ V:admin> but it was not allowing me to connect can any one check the above command is there any space given is incorrect please give the correct code to connect.

more ▼

asked Aug 03, 2011 at 10:53 PM in Default

avatar image

267 21 23 28

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The admins connections are limited to 2 RD sessions. Then depends on the configuration of the remote connections (whether multiple log-ins under the same name are allowed etc) you are able to log-in using the same name from move IP addresses. If you do not log-ff and instead disconnect, then when log-in from different IP the serer creates a new RD session.

However sometimes it happens even when you log-in from the same IP.

to connect to the server the correct syntax is `mstsc /v:serverIP`

If it happens, that you are out of available RD sessions, you can log-in directly to the console which is always available. To connect directly to the console you can use `mstsc /admin /v:serverIP` eventually `mstsc /console /v:serverIP`. The /admin or /console parameters depends on the version of the mstsc

Once you are connected to the console, you can run `tsadmin` in which you are able to manage the RD sessions. You can logoff existing sessions, disconnect, even you are able to connect to an existing session and take over it and then correctly log-of from that concrete session after checking that there is nothing important running.

Hope it helps.

more ▼

answered Aug 03, 2011 at 11:35 PM

avatar image

Pavel Pawlowski
22.7k 10 15 26

Thanks it was very helpful for me.

Aug 04, 2011 at 02:50 AM sunithalee143
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 03, 2011 at 10:53 PM

Seen: 540 times

Last Updated: Aug 03, 2011 at 10:53 PM

Copyright 2018 Redgate Software. Privacy Policy