Page 120 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Deepak Mehta, Lovely Professional University

Notes Unit 8: Configuring SQL Server Network
Communication

CONTENTS
Objectives
Introduction

8.1 Network Protocols
8.1.1 Shared Memory
8.1.2 TCP/IP
8.1.3 Named Pipes
8.1.4 VIA

8.2 Enabling and Configuring Protocols
8.3 Native Client Configuration
8.3.1 Client Protocols Properties (Order Tab)

8.3.2 Client Protocols - Shared Memory Properties (Protocol Tab)
8.3.3 Client Protocols - TCP/IP Properties (Protocol Tab)
8.3.4 Client Protocols - Named Pipes Properties (Protocol Tab)
8.3.5 Client Protocols - VIA Properties (Protocol Tab)
8.4 Summary

8.5 Keywords
8.6 Review Questions
8.7 Further Readings

Objectives

After studying this unit, you will be able to:

Learn about different types of network protocols used in SQL server
Understand the process to configure and secure the network protocols
Explain the use and functions of SQL Configuration Manager

Know how to configure native client configuration
Introduction

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. Most of the time, you do not need to change the server network configuration. Only
reconfigure the server network protocols if special network requirements.

Network configuration for SQL Server 2005 is done using SQL Server Configuration Manager.

114 LOVELY PROFESSIONAL UNIVERSITY