What are the permissions M-Files needs to access MS SQL without being a sysadmin?

When we installed M-Files on the client, we created a EDMS.USER as SYSADMIN.

The client says sysadmin is reserved for specific purposes and has disabled the user.

This has affected the the functioning of M-Files as M-Files requires this property to function properly.

Does anyone have we have M-Files function properly without SYSADMIN privileges.

We got the error below when the sysadmin property was removed:

M-Files Online
{D50219FC-5697-4BC4-ACAB-47F21B4823A7}

Bringing the vault online failed.
This operation is not possible without system administrator rights. Please add a system administrator role to the user "EDMS.USER" for the duration of the operation.

DBConnectionKeepAlive.cpp, 578, Bringing the vault online failed. (0x80040120)
DBConnectionKeepAlive.cpp, 302, Bringing the vault online failed. (0x80040120)
DBConnectionKeepAlive.cpp, 388, Bringing the vault online failed. (0x80040120)
DBConnectionKeepAlive.cpp, 388, This operation is not possible without system administrator rights. Please add a system administrator role to the user "EDMS.USER" for the duration of the operation. (0x80040120)
Vault.cpp, 4161, This operation is not possible without system administrator rights. Please add a system administrator role to the user "EDMS.USER" for the duration of the operation. (0x80040120)
Vault.cpp, 8952, This operation is not possible without system administrator rights. Please add a system administrator role to the user "EDMS.USER" for the duration of the operation. (0x80040120)
(M-Files 23.8.12892.6 2024-12-23T11:21:50.375Z)

Thank your kind responses.

Musa Zubairu

MZ Consulting Limited

Parents Reply
  • I'm sorry, but the linked document didn't help me. I have a similar problem.
    During the migration, we had an account with the sysadmin role. The migration went smoothly. Even after the customer removed the sysadmin role from the given login, everything worked smoothly until we tried to restart the service. At that moment, the error mentioned above occurred.

    This login has the "dbowner" role and according to the documentation, it should be enough. Where are we making a mistake? Does anyone have a similar experience?

Children
No Data