April 8, 2016 at 10:05 am
Hello Friends,
It might be very basic question for you friends, but how to allow multiple users on SQL Server installed on remote windows server 2012 machine.?
right now only two user can work at the same time if third one comes one of two who are active has to allow and get out himself.
we are building new server which will allow multiple user to work on the same time.
My question is once we install sql server on windows server machine what configuration needs to be done to achieve our goal on server machine as well as computers of people who will be logging into it.
do we need same number of instance similar to how many people will be working on it? if yes it means that many number of same database on the server and more space will be occupied right?[font="Comic Sans MS"][/font]
Thanks.
April 8, 2016 at 10:15 am
By default you can only have 2 RDP sessions connected at a time. To allow more you would need to install the RD Session Host role service. You would also need licensing after the grace period.
However, I'd suggest not RDPing to the server in the first place. Just connect to the instance using SSMS from your machine, and RDP only when absolutely necessary to interact with the OS (and even then many things can be done remotely).
Cheers!
April 8, 2016 at 11:01 am
I'd second what Jacob said. Working with SQL Server is always remote. Even if you are on the console, SSMS makes a remote connection, so setup networking and work from your own system.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply