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: Identifying the required users 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. Loftware recommends you keep the default name NiceAN. This makes potential future communication with Loftware support team easier.

  3. Click Next. If you set the required users in Phase 1: Identifying the required users 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 the 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 allows you to create the database and required users.

    To Choosing the user account for database creation 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.