Hi,
we are currently planing our environment for tests with Devolutions Server and would like to use an existing MSSQL server for that.
Because of that, the following question came up:
Does the MSSQL user for Devolutions Server need sa permissions or are DB owner permissions enough?
Best regards
its best practice to use the least privilege principle, so no, SA is not required
we have scripts to grant only what’s needed to each application running the platform : vaultRunner for iis, the one for the scheduler, etc.
for large enterprises with dedicated database administrators, they like to create the database as per their own specs, they can then give you the accounts with only required permissions
hope this clarifies things
Maurice