1. NiceLabel Help Center
  2. Control Center On-Premises Installation and Activation
  3. Advanced installations

Installing with database on a stand-alone SQL server

In this scenario, you have a stand-alone server that hosts your SQL Server and you plan to run the Control Center application on a separate server.

Complete these 2 phases:

  1. Phase 1. Identify the required Windows and database users.

  2. Phase 2. Install the Control Center application and set up your database connection.

Phase 1: Identifying the required users

To install and deploy the Control Center that works with a database that runs on a separate server, server cluster, or cloud server, have your required authorized users ready:

CCIG2019_Required_users.png

The required users for Control Center database

  1. Sysadmin. To create your Control Center database on the server that hosts your SQL Server instance, you need a system administrator or SQL user with administrative privileges.

    Note

    You can use Advanced installation > 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. See detailed instructions about DBTool in the Creating your database in a failover cluster topic.

  2. EPM_USER. A user (Windows or SQL) that enables the Control Center to read data from the database.

  3. EPM_DBADMIN. A user (Windows or SQL) that owns the database.

    There are two options to create EPM_USER and EPM_DBADMIN users:

    1. Automatically. During the installation, your Control Center installer creates these two users for you.

    2. Manually. Before the installation, you can manually add EPM_USER and EPM_DBADMIN users in these two places:

      • On your Windows system. In this case, the EPM users are Windows users.

      • On your SQL Server. In this case, the EPM users can either be Windows or SQL users.

      Note

      NiceAN is the default name for the Control Center database.

  4. Windows admin. To install the Control Center on the dedicated server, you need a Windows local or domain user with administrative privileges.

Phase 2: Installing the Control Center application with a stand-alone SQL Server

Before you start installing the Control Center, meet the following requirements:

  • You must be logged on to your computer as the administrator. If you are the only user on your computer, you are probably also the administrator.

  • Have your NiceLabel license key ready for activating the Control Center. You can complete the installation without your license key, but you cannot start working with Control Center unless you activate your license.

Tip

NiceLabel recommends accepting all the defaults that Control Center installer offers. This is how you enable your Control Center to automatically configure itself on your computer. This includes installing the SQL database and configuring the IIS.

Starting Control Center installer

  1. Close all open applications on your computer.

  2. After receiving your purchase confirmation email from NiceLabel, click the included link to download the Control Center installation file.

  3. Installation checks the installation package content. Start the installation.

  4. Select your Control Center installer language. Click OK. The installer now checks if your computer is properly configured.

    CCIG2019_Setup_Language_Selection.png

    Selecting your setup language

  5. Accept the license agreement. Click Next.

  6. Select the installation destination folder. Click Next.

Enabling Internet Information Services (IIS)

Enable Internet Information Services to install your Control Center.

CCIG10_Enabling_Internet_Information_Services__IIS_.png

Enabling Internet Information Services (IIS)

Note

If you don't see the Enable Missing IIS Features button, your computer is already properly configured. Continue with your installation.

The Control Center installer checks if the required .NET framework and IIS features are available and properly configured on your computer.

If the Control Center installer finds missing features, the Enable Missing IIS Features button appears automatically.

  1. Click the Enable Missing IIS Features button and the Control Center installer enables the missing .NET framework and IIS features for you.

  2. Accept the license agreement terms.

  3. Click Next to configure your website and storage settings.

Setting up website and storage access

In Control Center you centrally store your labeling files (label templates, graphics, Solutions) in Documents. Set up access to your Control Center storage in Documents and make your Control Center connections with other NiceLabel applications secure.

  1. This step is optional. Select HTTPS support to establish a secure client-server connection. NiceLabel recommends you secure your Control Center connections if the communication with clients uses open internet connections.

    Important

    After completing the installation, use the IIS manager to manually add HTTPS site binding and X.509 (SSL) certificate to your selected site. If you do not complete this step, your Control Center does not open. The steps for adding HTTPS site binding and SSL certificate in IIS are described in section Adding HTTPS site binding and SSL certificate in IIS.

  2. Define the WebDAV site settings. Type your site name and port number on which your site runs.

    This site is the WebDAV entry point into your Documents storage for all applications that work with files stored in your Documents. This site installs in the IIS on your current machine. NiceLabel recommends keeping the default settings.

    Important

    Make sure your selected port number is not in use by a site in IIS or any other application on this computer.

    CCOPIG10_CC_HTTPS_Support.png

    Enabling HTTPS and setting the WebDAV port

  3. Click Next. The installer checks if everything is OK and starts installing your Control Center.

Creating a database on stand-alone SQL Server

Your Control Center requires a database. This is why you must select an existing SQL Server instance on your server and create a dedicated database in this step.

Before you start with this installation, make sure you have all the required users from Phase 1 ready.

  1. Select the SQL Server instance from the drop-down menu or type in the name of your SQL Server instance using the following syntax: SQLSERVER\INSTANCE.

  2. Enter your Database name. NiceLabel recommends you keep the default name NiceAN. This makes potential future communication with NiceLabel support team easier.

  3. Click Next. If you set the required users in Phase 1 properly, Control Center installer creates the database and the required users automatically and proceeds to the next step.

    Note

    By default, Control Center installer always tries to create the database and the required users under the user account you are currently logged into. If Control Center installer discovers that your account is missing privileges for the selected SQL Server instance, the installation asks you to log in as a user that has the required set of privileges.

    If your installer can't proceed, here are three possible reasons:

    1. Your account is missing the privilege to create a database. The installer is trying to create a database while you are logged on as a user without sufficient privileges. Because the installer cannot continue, a window opens for you to log on as a Windows or a SQL user with a sysadmin role on your SQL Server instance.

    2. Your account is missing the privilege to create users. The installer is trying to create the EPM_USER and EPM_DBADMIN Windows users on the database server, and to set their access privileges. At this moment, the installer discovers that your account lacks the privilege to complete these two actions. As a result, the installer cannot continue and opens a window for you to log on as a Window or SQL user with granted "create user" privilege.

    3. Your account is missing both privileges - to create a database and to create users. In this case, Control Center installer discovers that your account lacks privileges to create your database and to create the required users. A dialog opens allowing you to log on using a user name and a password that allow you to create the database and required users.

    To customize the user account under which the installer creates the database, and the required users, open the Optional User Setting Changes.

    Note

    If you still cannot proceed, contact your local system administrator to identify the required users.

  4. Click Next. The installer checks if everything is OK and installs your Control Center. If the credentials issue persists, the login dialog appears automatically.

Completing Control Center installation

  1. Installing Web Printing site is optional. Before your browser launches and opens your Control Center Dashboard page, you can also start the installation of your Web Printing site.

    If the folder containing your Control Center installer also includes the installation file for Web Printing, you can select Install NiceLabel Web Printing after this installation is complete. If your installer does not find the Web Printing installation file, this option is not visible to you.

    CCIG2019_Web_Printing_after_installation.png

    Starting the Web Printing installation

    Do this to share your Applications (labels and Solutions) from your Control Center within your company or with external business partners.

    This opens the Web Printing installer. See section Installation steps for the Web Printing site for details on how to install your Web Printing.

  2. Click Finish.

Your browser opens the Control Center Dashboard page.

The address of your Control Center is: http://yourcomputername/EPM.

Important

Control Center cannot work properly with JavaScript disabled. If you are installing Control Center on a server, it is possible that due to security reasons, JavaScript is disabled by default. If there are no security issues, enable JavaScript in your browser and reload the page. Find more information in the How to enable JavaScript in Windows article.

If you experience any issues during the installation, please contact our NiceLabel support team at https://www.nicelabel.com/support.

Activate your Control Center with the key that you received via email after your purchase.