Configuring the SQL Server Browser service

After creating an account in MS SQL, you must configure the SQL Server Browser service.

To configure the SQL Server Browser service:

1. Open SQL Server Configuration Manager.
2. In the left pane, select SQL Server Services.

   A list of services opens.

3. Open the SQL Server Browser service properties in one of the following ways:
   • Double-click the name of the SQL Server Browser service.
   • Right-click the name of the SQL Server Browser service and select Properties from the context menu.
4. In the SQL Server Browser Properties window that opens, select the Service tab.
5. In the Start Mode field, select Automatic.
6. Select the Log On tab and click the Start button.

   Automatic startup of the SQL Server Browser service is enabled.

7. Enable and configure the TCP/IP protocol by doing the following:
   1. In the left pane, expand the SQL Server Network Configuration section and select the Protocols for <SQL Server name> subsection.
   2. Right-click the TCP/IP protocol and select Enable from the context menu.
   3. In the Warning window that opens, click OK.
   4. Open the TCP/IP protocol properties in one of the following ways:
      • Double-click the TCP/IP protocol.
      • Right-click the TCP/IP protocol and select Properties from the context menu.
   5. Select the IP Addresses tab, and then in the IPALL section, specify port 1433 in the TCP Port field.
   6. Click Apply to save the changes.
   7. Click OK to close the window.
8. Restart the SQL Server (<SQL Server name>) service by doing the following:
   1. In the left pane, select SQL Server Services.
   2. In the service list on the right, right-click the SQL Server (<SQL Server name>) service and select Restart from the context menu.
9. In Windows Defender Firewall with Advanced Security, allow inbound connections on the server on the TCP port 1433.

Page top