Setting up the database access user account

With IPF 4.1.x and later, you can specify either a Windows domain user account or a SQL Server user account as the user who will access the IPF Control Database. To avoid the need for Windows domain user requirements, we recommend the SQL Server user account, which we call the control DB user.

These are the setup requirements for each user type:

• For a control DB user, you can specify an existing SQL Server user or you can have the account created and given the correct permissions during the IPF installation process. Prior to installation, you must have an available SQL Server user with permissions to create the new IPF Control Database and to create or verify the control DB user. This requires sysadmin permissions or securityadmin and dbcreator permissions.
• For a Windows user, prior to installation you must set up an accessible Windows or Windows domain user account that has administrator permissions on the IIS servers and that is in the same domain as the SQL database server. This account is used to access the IPF Control Database and run the IPF Control Service. It is also used by the IIS application pools to support running portals.