--- title: "Step 2: Install SQL Server 2022 Express" slug: "step-2-install-sql-server-2022-express" updated: 2024-10-09T14:05:57Z published: 2024-10-09T14:05:57Z canonical: "docs.avontus.com/step-2-install-sql-server-2022-express" --- > ## 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 2: Install SQL Server 2022 Express SQL Server 2022 Express is a free application that you can download from Microsoft directly. If SQL Server 2022 Express is already installed, continue with installing [Database Tools](https://docs.avontus.com/docs/quantify-database-tools-for-sql-2022). If not, follow the procedures below. > **Please note that the following guide is for installing MS SQL Express 2017. 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.** To install SQL Server 2022 Express: 1. Log in to the server or client-server as a user with Administrative privileges and [download Microsoft SQL Server 2022 Express](https://www.microsoft.com/en-us/download/details.aspx?id=104781). Currently, only the 64-Bit version is available. 2. When the download has completed, Run or Open the file. The SQL Server Installation Center Wizard appears. 3. Select **Basic** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-GZJ4T01X.png) 4. Click **Accept** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-PM1TXMJG.png) The download will begin ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-16YXMG7G.png) 5. When the installation is complete, click **Customize** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-PI1Z4BFV.png) SQL will check for updates ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-69ZYGE1N.png) 6. If there are no updates, click **Next** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-2VSH2J8W.png) **Note:** If the *Install Rules* page appears, with a Windows Firewall warning, make sure that port 1433 is open in your firewall, then click **Next**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-KN9E63RJ.png) 7. Click **Installation** and then click **New SQL Server stand-alone installation or add features to an existing installation**. 8. Click **Next** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-CI92C51J.png) SQL will test to ensure SQL setup files can be installed, then the *License Terms* interface appears. 9. Click the **I Accept the License Terms and Privacy Statement** checkbox and click **Next**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-NMJKJB9G.png) 10. Disable **Azure Extension for SQL Server** (uncheck it), and click **Next** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-NEYMMCXF.png) 11. Select to disable **SQL Server Replication** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-JMAIP3IZ.png) Select any additional features, as desired. 12. Click **Next**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-VFQAHZKH.png) The *Instance Configuration* interface appears. 13. Click the **Default Instance** radio button > [!CAUTION] > **Warning:** Not using the default instance of SQL Server requires additional client setup and may result in user connection issues. Using a named instance of SQL Server will also prevent the installation of DB Tools and may result in additional IT requirements. USING THE DEFAULT INSTANCE IS HIGHLY RECOMMENDED. The name **MSSQLSERVER** will automatically appear in the Instance ID text field. 14. Click **Next.** ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-THQX2MI7.png) The wizard verifies the disk space requirements, then the *Server Configuration* interface appears 15. Click the **Startup Type** dropdown in the **SQL Server Database Engine** row and select **Automatic** from the dropdown that appear 16. Click **Next**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-I1HJELQQ.png) The *Database Engine Configuration* interface appears. 17. Click the **Mixed Mode** radio button in the **Authentication Mode** area of the dialog. 18. Click in the **Enter Password** text field and enter your SQL Server password. The password must meet SQL Server requirements. For more information, refer to the [Strong Passwords](http://msdn.microsoft.com/en-us/library/ms161962.aspx) article by Microsoft. 19. Click in the **Confirm Password** text field and enter your SQL Server password again. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-3134ZS0S.png) 20. Specify any additional **SQL Server Administrators**, as appropriate. The current user is added by default. 21. Click **Next**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-MVIF2HAP.png) Installation begins. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-UDD0DQVK.png) 22. If any dialogs appear before installation finishes, click **Next**. When installation is complete, the *Complete* interface appears. > **Note:** If issues were detected, resolve issues and restart installation. The *Computer Restart Required* dialog appears. **![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/8adacd2a-201b-4af7-9924-8a55193af6a9.png)** 23. Click **OK**. The *Complete* page appears. 24. Click **Close**. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-8DQ0YRHP.png) 25. Restart the computer.