Enabling SQL Server

  1. Log on to QTS as administrator.
  2. Go to Control Panel > Applications > SQL server.
  3. Optional: Change your SQL server password.
    Important:

    To prevent security risks, you cannot enable SQL server if the SQL server password is admin or blank.

    1. Underneath Database Maintenance, select Change Root Password.

      The Change Root Password window opens.

    2. Enter the new password twice.
    3. Click OK.

      QTS changes the root password and a confirmation window opens.

    4. Click OK.
  4. Select Enable SQL server.
  5. Optional: Enable TCP/IP networking.
    Tip:

    If you do not enable this option, the SQL Server is only configured as a local database server. Enable this option if you want to configure the SQL Server to be used as another web server on the network.

    1. Select Enable TCP/IP networking.
    2. Enter a port number.
      Note:

      The default port is 3306.

  6. Click Apply.

    QTS enables SQL server.