Creating a database without sysadmin permission

If you can not use the sysadmin server role for SQL, you can use this alternative solution and create a database by using SQL Server Management Studio (SSMS).

  1. Create BIFarm databases in SSMS.

    Create these empty databases:

    • BIFarmRepository
    • BIFarmConfig
    • BIFarmLog
    • BIFarmEPMStaging: Create this database only if you plan to install Infor EPM during the setup.
    • BIFarmModel: Create this database only if you plan to install Infor EPM during the setup.

    For more information, see Create a Database - SQL Server | Microsoft Learn

  2. Create a new SQL Login.
    Note: The SQL Login must be based on the name of the database.

    In the Server Roles page, select dbcreator and securityadmin.

    For more information, see: Create a Login - SQL Server | Microsoft Learn
  3. Map the Login to the repository database and create the database user.
    In SSMS perform these steps:
    1. Select Databases > [YourRepositoryDBName] > Security > Users.
    2. Right-click User name and select New User. Specify the User name (for example infor_service_user).
    3. For the Login name specify the login created in the previous step.
    4. Click OK.

    For more information, see: Create a Database User - SQL Server | Microsoft Learn

  4. Assign the db_owner role to the user in the database.
  5. Ensure the database is empty and does not contain any schema or data.
  6. During the Service Expert farm setup, select Existing database.
    Specify the name of the database and the credentials for the new user.
Proceed with the farm creation process.