SQL Server network configuration - SQL Shack - articles about

SQL Network Configuration

Network / December 9, 2016

All network protocols are installed by SQL Server Setup, but may or may not be enabled. This topic describes how to enable or disable a server network protocol in SQL Server 2017 by using SQL Server Configuration Manager or PowerShell. The Database Engine must be stopped and restarted for the change to take effect.


During setup of SQL Server Express a login is added for the BUILTIN\Users group. This allows all authenticated users of the computer to access the instance of SQL Server Express as a member of the public role. The BUILTIN\Users login can be safely removed to restrict Database Engine access to computer users who have individual logins or are members of other Windows groups with logins.


SQL Server and Microsoft data providers for SQL Server support TLS 1.0 and SSL 3.0. If you enforce a different protocol (such as TLS 1.1 or TLS 1.2) by making changes in the operating system SChannel layer, your connections to SQL Server might fail.

In This Topic

To enable a server network protocol

  1. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
  2. In the console pane, click Protocols for .
  3. In the details pane, right-click the protocol you want to change, and then click Enable or Disable.
  4. In the console pane, click SQL Server Services.
  5. In the details pane, right-click SQL Server (, and then click Restart, to stop and restart the SQL Server service.

Source: docs.microsoft.com