SQL Server Network Configuration

 

Hey guys, hope you are doing great. In this blog I am going to explain you about SQL Server Network Configuration and enabling/disabling different protocols.

SQL Server Network Configuration - SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols. It also provides the means to encrypt the communication between the SQL Server instance and the client applications and hide the SQL Server instance from being browsed. 

There are three main types of Network Protocols that you configure in SQL Server.

1.              TCP/IP

2.            Shared Memory

3.             Named Pipes

1. TCP/IP Protocols - This protocol connects computers with different hardware and operating systems and allows it to communicate together, as it includes network traffic routing standards with advanced security protection.

By default, the SQL Server instance listens on TCP port 1433, where the named instances located in the same server will be configured for dynamic TCP ports, selecting an available TCP port each time the SQL Server service restarted.

Procedure to configure the TCP/IP Protocols-

·  First open the SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP -> Right click -> Properties -> IP Addresses

·      Restart the SQL Server Services

Fig- 1

Fig- 2

How to Enable/Disable a TCP/IP protocols-

Go to SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Right click -> TCP/IP -> Enable/Disable

Fig- 3

2. Shared Memory Protocols - SQL Server Shared Memory protocol is used by clients to connect to the SQL Server instance that is running on the same machine. Shared Memory protocol can be used to troubleshoot other network protocols if these protocols are not configured correctly.

Procedure to configure a Shared Memory Protocols-

Go to SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Shared Memory -> Enabled/Disabled

Restart the SQL Server Services

Fig- 4

3. Named Piped protocols - 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.

Procedure to configure a Named Piped Protocols –

Ø Go to SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Named Pipes -> Right Click -> Enabled/Disabled

Ø Restart the SQL Server services

Fig- 5

Thank you very much for reading till end.