This is an example of an installation of a Microsoft SQL server (MS SQL Server 2012 is used) and the setup necessary for its connection to the MyQ Central server.

To install and set up the MS SQL server:

  1. Install the MS SQL Server and the MS SQL Server Management Studio application.

  2. Open the SQL Server Management Studio app (Windows Apps menu).

  3. Change the Server authentication setting of the MS SQL Server from the Windows Authentication mode to SQL Server and Windows Authentication mode (Server Properties, Security).

    Change server authentication mode
  4. Provide any user account (existing or new) with the Database Creator role. This account will be used to access the MS SQL server and manage the MyQ database there, which means that the MyQ administrator needs to know its credentials. The default language of the user who creates the database must be set to English (US).

    dbcreator role
  5. On MS SQL Server 2016 and older, you need to enable the common language runtime (CLR) integration feature. If you are using the MS SQL Server 2017 or newer, you can continue to the next step.

    Enable CLR

    To enable the CLR, use the following script:

    sp_configure 'clr enabled', 1;
    GO
    RECONFIGURE;
    GO
    SQL
  6. Leave the MS SQL Server Management Studio and open the SQL Server Configuration Manager app.

  7. Enable the TCP/IP protocol.

    Enabling TCP IP protocol
  8. Open the TCP/IP properties and set the IPAll TCP Port to 1433.

    Setting the TCP IP port to 1433
  9. Restart the SQL Server service.

    Restarting the SQL service
  10. Leave the SQL Server Configuration Manager.

  11. Create a TCP 1433 port inbound rule in Windows Firewall.

    Modify port in Windows Firewall
  12. Exit the setup.