Multiple users controlling the same servers?

Multiple users controlling the same servers?

avatar

OK, new user here. We have 3 people with the Enterprise RDM for remotely administering some servers.
Invariably, I will be doing something on a server and I get kicked out because someone ELSE decided THEY needed to do something.

Any ideas?
Instant messenger is no good because some people refuse to look at their message window.
Yelling down the hall is (unfortunately) also not an option.

It would be great if, when someone else tried to start a session, it would tell them "NO! There is already a remote session active"
Or something like that.

Is there a setting I am overlooking?

All Comments (11)

avatar

Maurice

avatar

Thanks for the fast response.
Unfortunately, that feature requires all the users be using a SQL data source and we are currently just using the default individual source. This is really a significant feature and I would like to take advantage of it.

Is it fairly simple to setup a shared data source and does it have to be SQL or MySQL?
How about a Visual FoxPro or ODBC kind of thing?

avatar

Bump!

Anyone have a "tried and true" method to simply set up a shared data source?

avatar

You need SQL Server or mySQL because we use the logs to find if someone is connected.

David Hervieux

avatar

SQL Server Express is free, you just need a computer to run the service that is accessible to all your team

Please consult

http://help.remotedesktopmanager.com/installation_configuresqlserver.htm

then

http://help.remotedesktopmanager.com/tipsandtricks_team.htm
edited by mcote on 10/14/2013

Maurice

avatar

I have installed SQL Express 2012 on my PC and gotten it working with RDM for my machine.

I got my co-worker to see if he could connect and he could not. I read that SQL Express is not configured for remote access out of the box so I went to the links for how to do that and references are for SQL 2005 and something called "SQL Server 2005 Surface Area Configuration tool" which does not exist in 2012 apparently.

How do I enable remote access in 2012?

avatar

Using SQL Server Management Studio
To configure the remote access option
In Object Explorer, right-click a server and select Properties.
Click the Connections node.
Under Remote server connections, select or clear the Allow remote connections to this server check box.

ref : http://technet.microsoft.com/en-us/library/ms191464.aspx

Maurice

avatar
















SQL Express comes with SQL Server Configuration Manager, not the Studio.
Consequently, there is no corresponding menu options as such.

I found this, which may help. Will advise: http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012

avatar

Right, but you still can download it

When you click download in here....

http://www.microsoft.com/en-us/download/details.aspx?id=29062

you get to choose to download the management studio tool. Its really useful to have. I dont know if it'll change the firewall rules as well, but you already found instructions for that.

Maurice

avatar













Thanks for that! Didn't see it listed there.

avatar

OK, got it working.

SQL Express 2012 is a little quirky to set up, but once it is - the rest is fine.