Best Practice for several User on several PC / Termianal Servers
Best Practice for several User on several PC / Termianal Servers
Hello all,
I would like to know what is the best way to provide users working on different systems (workstations and terminal servers) with their own RDM environment.
I myself use RDM on multiple PCs and have a central MariaDB for this and can access the same data within RDM on all systems.
How can I ensure the same if there are multiple users who each need their own environment?
The systems usually do not have internet access. There is no MS-SQL server because there is no license for it. MariaDB or MySQL would not be a problem.
Many thanks
TBC
All Comments (3)
Hello,
We're in the middle of deprecating support for all MySQL based databases. Sadly, our support staff was overwhelmed with issues that were caused by actions outside of our control.
With SQL Server Express, which is multi plaform and free, our case history shows that we have better control of the environment. If you insist on each using having their own environments, I would simply spin up an individual database for each user, this on the same SQL server.
Best regards,
Maurice
Hello,
many thanks for helping!
OK SQL Express would be a possibility. Are there any other possibilities? If not, how would I need to proceed with the SQL Express solution to create a database for each user.
We use MS Active Directory if that makes things a little easier.
We would plan to run SQL-Express on Ubuntu 20.04.
RDM would be the enterprise version that would be used. We are still open about the procedure since nothing is installed yet.
Thanks in advance
TheBob
Hello,
RDM Enterprise would be required since you are using a team data source (SQL Server).
You would need to create a database for every user in the SQL Server, login as a user that has db_owner rights to that newly created database (or the sa account) and then create the RDM database for each user. You can refer to this KB: https://help.remotedesktopmanager.com/installation_configuresqlserver.html
Once it is created, you can add the user under Administration > Users. With integrated security as the login method, it will simplify the authentication:
Best regards,
Richard Boisvert