[en] 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.
[en] The Optional User Setting Changes window
[en] Configure Optional User Setting Changes in two cases:
-
[en] You are currently logged with a user account with insufficient privileges for creating your database and the required users on your SQL Server instance.
-
[en] You are planning to use the existing Windows or SQL users as your EPM_USER or EPM_DBADMIN users.
[en] Learn more about the required users for installing Control Center in the section Identifying the required users.
[en] 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.
-
[en] Define the user that creates the database on the selected SQL Server instance. There are two options:
-
[en] Use the currently logged-on user. This is the Windows local or domain user under which you are installing the Control Center.
注意
[en] 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.
-
[en] 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.
重要
[en] Whichever option you choose, the user must have the sysadmin role on your SQL Server instance.
-
-
[en] Create users EPM_USER (to read the data) and EPM_DBADMIN (to own the database). There are two options to create these two users:
-
[en] Automatically. The Control Center installer creates these two users for you. If you select this option, the installer creates EPM_USER and EPM_DBADMIN users as Windows users.
-
[en] 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.
[en] Read how to configure the manually created EPM users in the section Configuring securables for custom database users.
-
[en] 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.
-
[en] If you select SQL Authentication, define the existing SQL users that take the EPM_USER and EPM_DBADMIN roles.
-
-