1. NiceLabel Help Center
  2. 知识库
  3. 安装和更新

[en] The "Optional User Setting Changes" button is greyed out or disabled when installing Control Center

目前还没有官方翻译。

[en] Problem

[en] You try to install Control Center and you don't have the rights to create or manage users in the SQL database. During the Control Center installation, you can create or modify Control Center users (EPM_DBADMIN and EPM_USER). On some rare occasions, the "Optional User Setting Changes" button is greyed out or inactive.

36_CC_install9.png

[en] Solution

[en] Download and install NiceLabel DBTool to manually create SQL users for Control Center, then reinstall Control Center.

  1. [en] Create a VM snapshot or backup NiceAN database on your SQL server.

  2. [en] Unzip the downloaded .zip file and copy the DBToolSFX.exe. file to some folder on your hard drive.

  3. [en] Run the DBToolSFX.exe to create the DBTool folder. Open the folder and run the DBToolGui.exe file.

  4. [en] NiceLabel Database Setup Tool opens. Click Create or upgrade database.

  5. [en] Enter your SQL server name.

  6. [en] In the Database name edit field, enter a database that doesn't exist yet, for example, NiceAN_2. Don't use the existing name (NiceAN is default).

  7. [en] Select your authentication mode (SQL server authentication, where the default user is usually "sa", or Windows Authentication), then click Connect.

  8. [en] The Database Information section opens. In the Users creation drop-down menu, select Assign required roles to the existing users.

  9. [en] Select Authentication for database users.

    • [en] For SQL Server Authentication: Enter your SQL Server passwords for EPM_DBADMIN and EPM_USER.

    • [en] For Windows Authentication:

      • [en] For domain users: update EPM_DBADMIN edit field to your_domain\EPM_DBADMIN and EPM_USER edit field to your_domain\EPM_USER.

      • [en] For local users: keep the EPM_DBADMIN and EPM_USER fields unchanged. You can also rename EPM_DBADMIN edit field to your_localuser\EPM_DBADMIN and EPM_USER edit field to your_localuser\EPM_USER.

      • [en] Enter passwords for EPM_DBADMIN and EPM_USER.

  10. [en] Click Create database.

  11. [en] A window with the notification about successful database creation opens. Click Save settings and exit.

  12. [en] File Explorer opens with the newly created UserData.ini file. Save the UserData.ini file in the folder where the Control Center installation file is located.

  13. [en] Open the UserData.ini file with the text editor (Notepad) and change the database name (NiceAN_2) to NiceAN (which is the default value; yours might be different).

    37_CC_install10.png
    38_CC_install11.png

  14. [en] Install NiceLabel Control Center.

[en] After you finish the Control Center installation, open Microsoft SQL Server Management Studio and delete the newly created database (NiceAN_2).