For SQL Server setup, on the Database tab, you must complete the following fields:
Note: | The following configuration applies to both SQLOLEDB and SQLNCLI. |
Database Server (domain name, IP address, or computer name)
Database Name (name of the database that will be created)
User name (database user name)
Password (database password)
If Use Windows Integrated Security is selected, when FDM is accessed from the Web, the FDM application server account is used to log on to the SQL Server database. When FDM is accessed from Workbench, the account used to log on to Workbench is used to log on to the SQL Server database.
If Use Windows Integrated Security is not selected, you must enter a SQL Server account. When you create an FDM database, the account used to log on to the SQL Server database must be a SQL Server system administrator or have database creator rights and bulk insert administrator rights. After the database is created, the account can be limited to bulk insert administrator rights and db_owner rights.