Which server is right so 3 users can connect to Remote Desktop Services?

John 21 Reputation points
2023-10-17T18:10:04.0633333+00:00

Three remote users need to access a SQL database on a desktop computer. At times all will need access to the SQL database at the same time. I was told Remote Desktop Services was a good option. I have the following questions.

  1. What server edition would be best for my needs? Is there any additional costs other than the server license so the three users can use Remote Desktop to access the SQL database?

The computer will be used just to access that database. Nothing else.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,239 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.2K Reputation points MVP
    2023-10-20T15:30:20.9966667+00:00

    Either Server 2019 or Server 2022 will work fine. Yes, if you add the remote desktop services role then RDS Cals will be required. Please don't forget to close up the thread here by marking answer if the reply is helpful and open a new thread if you need assistance with RDS setup.


1 additional answer

Sort by: Most helpful
  1. Dave Patrick 426.2K Reputation points MVP
    2023-10-17T18:13:58.3933333+00:00

    Both Server Standard and DataCenter allow two concurrent remote desktop sessions. If you needed more then you'll need to add the Remote Desktop services role, complete the configuration then also add RDS Cals for each device or user.

    --please don't forget to close up the thread here by marking answer if the reply is helpful--