MS SQL Server setup example

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).

   

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).

   

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.

   

   To enable the CLR, use the following script:

   SQL

   sp_configure 'clr enabled', 1;
   GO
   RECONFIGURE;
   GO

6. Leave the MS SQL Server Management Studio and open the SQL Server Configuration Manager app.

7. Enable the TCP/IP protocol.

   

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

   

9. Restart the SQL Server service.

   

10. Leave the SQL Server Configuration Manager.

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

    

12. Exit the setup.