SQL Server protocols

SQL Server Network Interface is a protocol layer that establishes the network connection between the client and server. SQL Server supports 4 protocols.

1. Shared Memory
2. Named Pipes
3. TCP/IP
4. VIA

Shared Memory:
It is default protocol used to connect client and SQL server on the same machine.

Named Pipes:
Client and Server will connect within a LAN(Local Area Network). It has certain limitations.

TCP/IP:
TCP/IP is most used protocol for SQL Server. Client establishes connection with SQL server using an IP address and port number 1433. We can access the databases using internet hence there are no boundaries for this protocol.

VIA is a wirless intranet protocol for connecting client and server within a certain range.

Important:
To establish a secure sql server connection, we need a port number along with protocol.
Default port number for TCP/IP protocol is 1433

Powered by k2schools