---
title: "Step 4: Configure the SQL Server 2022 Instance"
slug: "step-4-configure-the-sql-server-2022-instance"
updated: 2024-10-09T14:13:22Z
published: 2024-10-09T14:13:22Z
canonical: "docs.avontus.com/step-4-configure-the-sql-server-2022-instance"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Step 4: Configure the SQL Server 2022 Instance

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

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-HB2X8XXP.png)
2. Right-click the main **Server** node and select **Properties** from the menu that appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-U3Y1F4VT.png) The *Server Properties* dialog appears.
3. Click **Connections**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-85GAOPE7.png) The *Server Properties* dialog refreshes.
4. Click the **Allow remote connections to this server** checkbox (to put a check in it) and click **OK.** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-BFXS7NK7.png)

## 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. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-4T9XYZUV.png)
3. Right-click **Named Pipes** and select **Enable** from the menu that appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-Z6IJJQYB.png)
4. Right-click **TCP/IP** and select **Enable** from the menu that appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-YSFXO54F.png)
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. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-XTFLK7US.png)
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.