Where is sql server network configuration

Most of the time, you do not have to change the server network configuration. Only reconfigure the server network protocols if special network requirements. More than one protocol can be enabled. You must enable all protocols that you want clients to use. All protocols have equal access to the server. This means they select an available port when the SQL Server service is started. When configured for dynamic ports, the port used by SQL Server may change each time it is started.

Configure SQL Server to use a specific port, so you can configure the firewall to allow communication to the server. You can configure the named pipe protocol to listen on a designated named pipe. The Database Engine can only listen on one named pipe, but you can change the pipe to another name if you wish. The Database Engine can be configured to require encryption when communicating with client applications. Support for Extended Protection for Authentication by using channel binding and service binding is available for operating systems that support Extended Protection.

At the details area in the right, right-click on the protocol you are interested in and click on Enable or Disable as below:. Enabling or disabling the SQL Server network protocols requires restarting the SQL Server service to take effect, which can be done from the same console.

SQL Server Shared Memory protocol is the simplest protocol, as it has no configurable settings to be tuned in order to use it. Shared Memory protocol can be used to troubleshoot other network protocols if these protocols are not configured correctly.

This protocol connects computers with different hardware and operating systems specs and allows it to communicate together, as it includes network traffic routing standards with advanced security protection. It is better to configure the SQL Server named instance to listen on a specific static port rather than using dynamic ports, in order to configure the firewall to allow communication to the SQL Server on that specific TCP port.

Once you finish with all IP addresses, click OK. We can optimize the use of this DMV, as it returns only the SQL handle for that session and not the actual query text. To get the query text, the sys. The last network protocol we will discuss here is Named Pipes.

This protocol is designed for local area networks, to provide a way for inter-process communication among the processes running on the same machine or on a remote computer in the same LAN, where the output of one process is the input of the second one, without having the penalty of involving the network stack. Contents Exit focus mode. Is this page helpful? Yes No.

Any additional feedback? Skip Submit. Submit and view feedback for This product This page. View all page feedback.