Skip to main content
Skip table of contents

Central Server database setup

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. Fill in the setup fields with the following information:

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

    2. Log database name: this is 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. You can alternatively use Windows Authentication.

  3. Before you can continue, it is necessary to manually create the main and log databases MyQ will be using. You can use the creation scripts that are available to you under the 'Database name' and 'Log database name' fields. Run the scripts on your MS SQL server and they will create databases using the names you have provided in Step 2.

  4. Once the databases are successfully created, click Next to continue. MyQ Central Server Easy Config will run the Database Prerequisites Check.

  5. Click Finish to leave the MyQ Database Wizard.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.