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

sunithalee143 gravatar image

267 15 23 25

(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

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 442 times

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