Page 125 - DCAP508_DATABASE_ADMINISTRATION

Unit 8: Configuring SQL Server Network Communication

8.3.4 Client Protocols – Named Pipes Properties (Protocol Tab) Notes

In Microsoft SQL Server Configuration Manager use the Protocol tab on the Named Pipes
Properties dialog box to view or modify the description of default pipe. To connect to a different
pipe, type the pipe in the Default Pipe box.
Options
Default Pipe: Specifies the default pipe the Named Pipes Net-library will use to attempt to
connect to the target instance of SQL Server. By default, SQL Server listens on: \\.\pipe\sql\query
To connect to the default pipe, enter sql\query
Enabled: Possible values are Yes and No.

8.3.5 Client Protocols – VIA Properties (Protocol Tab)

In Microsoft SQL Server Configuration Manager, use the Protocol tab on the VIA Properties
dialog box to view or specify the following options for the Virtual Interface Adapter.
Options
Default NIC: Indicates which Network Interface Card (NIC) the VIA protocol is bound to. NICs
are numbered, starting at zero. Computers with only one NIC will indicate 0.
Default Server: VIA port that VIA is listening on when accepting connections from VIA clients.
Enabled: Possible values are Yes and No.

Self Assessment

State true or false:
7. To connect to the default pipe, enter sql\query
8. NIC stands for Network Indicator Card.
9. SQL Server Native Client is the network library that client computers use to connect to
SQL Server, starting with Microsoft SQL Server.
10. The settings configured in SQL Server Native Client Configuration, are used on the
computer running the server program.
11. The default value of KEEP ALIVE parameter is 40000 milliseconds.

8.4 Summary

Server network configuration tasks include enabling protocols, modifying the port or
pipe used by a protocol, configuring encryption, configuring the SQL Server Browser
service, exposing or hiding the Microsoft Database Engine on the network, and registering
the Server Principal Name.
Shared memory is the simplest protocol to use and has no configurable settings. Clients
that use MDAC 2.8 or earlier cannot use this protocol.

TCP/IP includes standards for routing network traffic and offers advanced security features.
Named Pipes is a protocol developed for local area networks. For named pipes, network
communications are typically more interactive

LOVELY PROFESSIONAL UNIVERSITY 119