Choosing the user account for database creation

While installing your Control Center, you might learn that your current account doesn't have sufficient privileges to create your database and required users on the server that hosts your SQL Server instance. In this case, your Control Center installer offers you Optional User Setting Changes. These settings allow you to change your current user account under which you are trying to create your Control Center database or the required EPM_USER.

Note

You can use DBTool (Database Setup Tool installer) to create your Control Center database. In this case you don't need sysadmin privileges. A user that creates Control Center database must be a dbowner or a member of dbowner role. You can download DBTool from the Loftware Utilities page. The downloaded DBTool is compatible only with the latest Control Center version. For previous DBTool versions, contact our support.

Configure the Optional User Setting Changes in two cases:

  • You are currently logged with a user account with insufficient privileges for creating your database and the required users on your SQL Server instance.

  • You are planning to use the existing Windows or SQL users as your EPM_USER or EPM_DBADMIN users.

Learn more about the required users for installing Control Center in the section Phase 1: Identifying the required users.

Use the Optional User Setting Changes to create or edit the required users for database management and for the communication between your Control Center and its database.

  1. Define the user that creates the database on the selected SQL Server instance. There are two options:

    • Use the currently logged-on user. This is the Windows local or domain user under which you are installing the Control Center.

      Note

      You can use the Windows local user if the SQL Server runs locally on your machine. If the SQL Server runs on another machine within your domain, use a domain Windows user.

    • You can specify another user that creates the database. This can either be a Windows or a SQL user. Define this using your selected Authentication type.

      Important

      Whichever option you choose, the user must have the sysadmin role on your SQL Server instance.

  2. Create users EPM_USER (to read the data) and EPM_DBADMIN (to own the database). There are two options to create these two users:

    1. Automatically. The Control Center installer creates EPM_USER and EPM_DBADMIN users as Windows users.

    2. Manually. You can manually create the EPM_USER and EPM_DBADMIN users on your system before the installation. You can also use other existing Windows or SQL users to perform the roles of EPM_USER and EPM_DBADMIN users.

      Read how to configure the manually created EPM users in the section Creating and configuring the database users.

      • If you select Windows Authentication, define the names of the predefined Windows users that take the EPM_USER and EPM_DBADMIN roles. Keep the default names to let the dedicated EPM users take these two roles, or type the names of other existing Windows users that take the roles instead.

      • If you select SQL Authentication, define the existing SQL users that take the EPM_USER and EPM_DBADMIN roles.