To access the SQL Server database, FDM uses the FDM SQL Server account. When accessing the database, FDM can use Windows Integrated Security or a specified SQL Server account. When FDM is accessed from the Web, and Windows Integrated Security is used, the FDM Application Server account is used to log on to the SQL Server database. When the Workbench client is used, the user name used to log on to Workbench is used to log on to the SQL Server database.
The account used to create a database must have SQL Server system administrator or database-creator and bulk-insert administrator rights. After the database is created, the account can be limited to bulk-insert administrator and db-owner rights. The account used for running the MSSQLServer Windows service must have read access to the FDM Inbox folder.