Page 126 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes VIA stands for Virtual Interface Adapter (VIA) protocol.
By default, the only network protocols enabled ob most of the edition of SQL server are
TCP/IP and Shared memory.

SQL Server Native Client is the network library that client computers use to connect to
SQL Server, starting with Microsoft SQL Server.

8.5 Keywords

Keep Alive: This parameter (in milliseconds) controls how often TCP attempts to verify that an
idle connection is still intact by sending a KEEPALIVE packet.
Keep Alive Interval: This parameter (in milliseconds) determines the interval separating
KEEPALIVE retransmissions until a response is received.
Named Pipes: Named Pipes is a protocol developed for local area networks.
SQL Server Native Client: SQL Server Native Client is the network library that client computers
use to connect to SQL Server, starting with Microsoft SQL Server.
TCP/IP: TCP/IP includes standards for routing network traffic and offers advanced security
features.

VIA: VIA stands for Virtual Interface Adapter (VIA) protocol.

8.6 Review Questions

1. Explain the different types of network protocols used in SQL server.
2. Describe the process to configure and secure the network protocols.

3. Explain the use and functions of SQL Configuration Manager in network configuration.
4. Discuss the process to configure native client configuration in SQL Server.
5. Explain the functions of SQL Server Configuration Manager.
6. Differentiate between named pipes and TCP/IP sockets.
7. Illustrate the working of Virtual Interface Adapter (VIA).

8. Explain the concept of enabling and configuring protocols.

Answers: Self Assessment

1. Shared memory 2. TCP/IP
3. local area networks 4. Virtual Interface Adapter
5. TCP/IP and Shared memory. 6. shared memory

7. True 8. False
9. False 10. True
11. False

120 LOVELY PROFESSIONAL UNIVERSITY