Configure Current SQL Instance
If your current version is 19.1.3 or below, follow these instructions as part of the upgrade procedure. Otherwise, this procedure isn't relevant to your upgrade.
Open SQL Server Configuration Manager (a tool installed with SQL Server), and follow these steps to configure the database instance:
-
Enable and configure TCP/IP
-
Under SQL Server Network Configuration > Protocols for {Instance Name}, enable TCP/IP
-
Double click TCP/IP to open its configuration
-
On the IP Addresses tab, scroll down to IPAll
-
Remove the
0
value from TCP Dynamic Ports (so that it now appears blank) -
In TCP Port, enter the port number used to communicate with this database instance
-
To use the default value, enter
1433
-
-
Click the OK button to save your changes
-
-
In SQL Server Services, right-click the SQL Server service for the relevant instance and select Restart
-
Configure and start the SQL Server Browser
-
In SQL Server Services, double click the SQL Server Browser service to open its configuration
-
On the Service tab, set the Start Mode value to
Automatic
-
Click the OK button to save your changes
-
Right-click the SQL Server Browser service and select Start
-
-I came here while upgrading, take me back to the upgrading steps overview-