login to box - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-12-04 : 12:59:25

I am trying to login to one box, sql server installed on that box. But it is saying execeeded the maximum user connections, how do we find out the users id\name those who already connected to that box.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-04 : 13:02:14

You are talking about Remote server right. Other admins needs to get out before you can enter.

celestia
Starting Member

2 Posts

Posted - 2008-12-04 : 14:04:19

Looks like you've exceeded the max connections for terminal services (mstsc/rdp). Ask your network guys to check the connections on that server. If one or more of the connections is inactive, they can reset it and you'll be able to log in. When you finish working on that server, be sure to go to the Start menu and log out properly. Don't just click on the X in the corner as this won't release the connection for someone else to use.

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-01-02 : 21:30:13

Celestia,Thanks for your information

I found the solution
Login to another box(same domain)
from there run-tsadmin
You can able to see all servers belongs the same domain then search for server, you will see the who are all the users connected to that particular server then contact them

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-02 : 23:18:31

You could access the console from Remote Desktop, which gives you one extra connection past the max allowed: http://weblogs.sqlteam.com/tarad/archive/2006/10/12/13989.aspx

Also, sodeep's reply wasn't bad. Your post didn't give much detail. It didn't tell us TS or RDP, so be sure to include that info next time.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-03 : 07:09:04

quote:
Originally posted by laddu

Celestia,Thanks for your information

I found the solution
Login to another box(same domain)
from there run-tsadmin
You can able to see all servers belongs the same domain then search for server, you will see the who are all the users connected to that particular server then contact them

So I missed the comments about my reply. Ahh... you edited before I could reply you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources