This article assumes you have a Microsoft SQL Server instance installed and running. 

If not then take a look at How Do I Install A Microsoft SQL Server?

Type SQL Server Configuration Manager into your Windows Search Bar

If you don't see SQL Server Configuration Manager you can directly run the program from the following locations

• SQL Server 2022 - C:\Windows\SysWOW64\SQLServerManager16.msc

• SQL Server 2019 - C:\Windows\SysWOW64\SQLServerManager15.msc

• SQL Server 2017 - C:\Windows\SysWOW64\SQLServerManager14.msc

• SQL Server 2016 - C:\Windows\SysWOW64\SQLServerManager13.msc

• SQL Server 2014 (12.x) - C:\Windows\SysWOW64\SQLServerManager12.msc

• SQL Server 2012 (11.x) - C:\Windows\SysWOW64\SQLServerManager11.msc

SQL Server Configuration Manager will launch with the following screen

1. Expand out "SQL Server Network Configuration"

2. Select the name of your SQL Server Instance. In this case we are selecting the EZA instance

Select TCP/IP, then right click and select Enable

You will be prompted "Any changes made will be saved; however, they will not take effect until the service is stopped and restarted"

1. Restart the Service to pick up the changes

2. Click on SQL Server Services

3. Select the SQL Server Named Instance to restart. In this case we are selecting the EZA instance

Right click on the row and select Restart

Your SQL Server Instance will now allow remote connections

Install Rules - Click the Next button

Uncheck the Azure Extension for SQL Server Option and Click the Next button

1. Uncheck the SQL Server Replication Option

2. Uncheck the Machine Learning Services and Language Extensions Option

3. Uncheck the Full-Text and Semantic Extractions for Search Option

4. Click the Next button

Name your Database Service Instance (Suggested)

1. Named Instance: EZAK

2. Instance ID: EZAK

1. Change the Startup Type for the "SQL Server Browser" to Automatic

2. Click the Next button

1. Select Mixed Mode (SQL Server authentication and Windows authentication) option

2. Enter a password for the SQL Server system administrator (sa) account. This should be a strong password.

3. Click the Next button

If all goes well you will have a successful SQL Server install, Click the close button

Your Microsoft SQL Server is now ready to use with EZ Arms Keeper