Configure the server

Do the following:

1. Start SQL Server 2017 Configuration Manager.

2. From the left of the dialog, select SQL Server Network Configuration > Protocols for SQLEXPRESS.

3. Right-click TCP/IP, and select Properties.

   

   The TCP/IP Properties dialog opens.

4. For Enabled, select Yes.

   

5. Select the IP Addresses tab.

6. Below IPAll, in the TCP Port section, enter 1433 as the value. This is the default communication port for SQL Server.

7. Click OK.

8. From the left of the dialog, select SQL Server Services.

9. Right-click SQL Server (SQLEXPRESS), and select Restart.

   

The service restarts itself with your modifications. You can close the program.

Next, connect to the SQL Server database.