Microsoft SQL Server Roles and Privileges

Database users must be assigned ownership of the database, which provides DB_OWNER privileges, and BULK_INSERT.

Note:

For FDM, Windows accounts that run MSSQL Server Windows service must have read access to the FDM Data folder.