Once the MyQ Central server is installed, the MyQ Central Server Easy Config application opens and you are asked to select and set the MyQ database. The two following sections describe the setup of the database after the installation.

If you have deselected the Embedded Database option during the installation, the MyQ Embedded database option is no longer available on the MyQ server.

Setting up the Embedded Database

To set up the Embedded database:

  1. Select the Embedded Database (recommended) option, and click Next. The database is installed and upgraded if needed.

    Selecting the Embedded database type
  2. Click Finish to leave the MyQ Database Wizard.

    Click finish to exit the setup

Setting up an MS SQL Database

To set up an MS SQL database:

  1. Select the Microsoft SQL Server 2012 or higher option and click Next.

    Selecting the MS SQL server 2012 or higher database type option
  2. Select if you want to use an existing MS SQL Database, or to create a new one.

  3. Fill in the setup fields with the following information:

    1. Database name: name of the new MyQ MS SQL database (for example MyQDatabase)

    2. Log database name: this automatically filled according to the Database name

    3. Database server address: the IP address or the hostname of the MS SQL server

    4. Server port: TCP port used for communication with the MS SQL server; by default it is 1433. In case of a Local database, the Server port field must be left empty.

    5. Username/Password: Login credentials for accessing the MS SQL database management. The login account has to have the public fixed server role for access to the MS SQL database.
      After you fill in the fields, click Next to create the new database. You can alternatively use Windows Authentication. The Enter database creation credentials dialog box appears.

      SQL DB connection information
  4. In the dialog box, you need to provide credentials of an account with the permission to create databases. Enter the Username and Password of a user with the dbcreator fixed server role (and also the sysadmin server role if you are using the MS SQL Server 2017), and then click Next. The database is created (it may take a few minutes).

    Enter database creation credentials dialog box
  5. Click Finish to leave the MyQ Database Wizard.

An MS SQL database does not support importing temporary cards.