Step 4: Configure the SQL Server 2022 Instance

  • Updated on Oct 9, 2024
  • Published on Aug 7, 2023
  • 1 minute(s) read
  • EN
 Prev Next

Before you can use SQL Server with Quantify, it must be configured. If you do not configure SQL Server, it may prevent Quantify from connecting to it. You do this in the SQL Server Management Studio and in the SQL Server Configuration Manager.

Please note that the following guide is for installing MS SQL Express 2022. Your installation of SQL may vary depending on the version of MS SQL you have selected (there may be slight differences in screenshots). Please note that it is critical that MS SQL has the settings as detailed within the following instructions for Quantify to function as expected.

SQL Server Management Studio

  1. Open SQL Server Management Studio for SQL Server 2022.

    Note: If the Connect to Server dialog appears, click in the Server Name text field and enter the appropriate server name, then click Connect.

     

  2. Right-click the main Server node and select Properties from the menu that appears.
     
    The Server Properties dialog appears.

  3. Click Connections.
     
    The Server Properties dialog refreshes.

  4. Click the Allow remote connections to this server checkbox (to put a check in it) and click OK.


SQL Server Configuration Manager

  1. Open SQL Server Configuration Manager for SQL Server 2022.

    Note: If you are running Windows 8 or higher, please see below for details.


    The SQL Server Configuration Manager dialog appears.

  2. Expand the SQL Server Network Configuration node and click Protocols for MSSQLSERVER.
    The SQL Server Configuration Manager dialog refreshes.
     

  3. Right-click Named Pipes and select Enable from the menu that appears.
     

  4. Right-click TCP/IP and select  Enable from the menu that appears.
     

  5. Click the SQL Server Services node.
    The SQL Server Configuration Manager dialog refreshes.
    OPTIONAL:

    1. Double-click SQL Server (MSSQLSERVER).
      The SQL Server Properties dialog appears.

    2. Click the Log On tab.

    3. Click the Log on as radio button,

    4. Click the menu under the radio button and select Log On As to LocalSystem.

    5. Click OK.

  6. Right-click SQL Server (MSSQLSERVER) and select Stop from the menu that appears.
     

  7. Once the service stops, right-click SQL Server (MSSQLSERVER) and select Start from the menu that appears.

  8. Close the SQL Server Configuration Manager dialog.

Firewall Settings

If Windows Firewall is enabled or running on clients, open port 1433 on each client.