Protocols available in SQL Server:
SQL Server network interface(SNI) 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 with in a LAN.
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 a port number(1433).
We can access the databases using internet hence there are no boundaries for this protocol.
VIA(Virtual Interface Adaptor):
Via is a wireless internet protocol for connecting client and server with certain range.
The VIA protocol is deprecated.
This feature will be removed in a future version of Microsoft SQL Server.
How to see this protocols:
Goto SQL server configuration manager--->click SQL Server Network Configurations-->protocols for particular instance.
This comment has been removed by the author.
ReplyDelete