Who Is This Use Case For?
This use case is for organizations currently running a newly deprecated MySQL or MariaDB database backend for Remote Desktop Manager (RDM).
As of version 2022.1.11.0, RDM no longer supports MySQL or MariaDB as a data source. Typically, this database is used with Linux servers. An organization may not be ready or desire a migration to Windows servers for the RDM data source.
What then is a supported Linux server database backend for RDM? Microsoft SQL Server Express is newly supported on Linux, with excellent management tools, and support from RDM. Once the desired vaults are migrated, you will have a familiar server environment and a secure and performant database.
How it works
- Install MS SQL Server Express on a Linux Server.
- Open the necessary firewall port, typically 1433.
- Connect RDM to the MS SQL database via the sa user to create the RDM database.
- Add any necessary accounts to the RDM instance.
Summary of Benefits
- Familiar Server Environment: Leverage existing expertise in Linux server management instead of migrating to a Windows server backend.
- Proven and Secure Database: Microsoft SQL Server has been used in enterprises and organizations worldwide for several decades with proven success.
- Excellent Management Tools: Leverage Microsoft SQL Management Studio, CLI tooling, and DbaTools for PowerShell to ease management.
Learn more about how Devolutions can help your organization increase security, ensure compliance, and improve user management:
In the technology world, your use cases are only as effective as the value someone’s deriving from them. That’s why at Devolutions we are doing our best to help you make the right choice with easy to understand use case examples for you and your team for an ideal productive environment. Read more Use Cases