Transcript SQL server Network utility

INFS 752
Summer
Juan Salazar
Please right click the symbol in the lower right corner, and then
press preview, to hear the presentation for each page.

SQL Server

This is a relational database management system.
 This assists with encryption, analysis, reporting, among
other areas.

SQL

Structured Query Language
 A database querying language.
 Used in requesting and modifying data in a database.

With the installation of the SQL Server

Client Network Utility is also installed.

Client Network Utility



Automatically installed on each of the Windows
operating systems, starting with Windows 2000.
This is the client-based counterpart to SQL Server
Network Utility.
Changes the way that the client machines
communicate with the SQL Server.
 Ex. Telling ADO (Active X Data Objects) which
network protocols to use in connecting to SQL Server.

cliconfg.exe

The executable for the network utility.

Tabs for the Client Network Utility window.

Tabs:

General
 Lists enabled (by order) and disabled protocols.
 Can force the use of protocol encryption and enable
shared protocol memory.
 Use to set Net Libraries used.

Alias
 Use to create aliases, or view the existing ones.
 Register server instances and aliases.
 In its window, can see server alias configuration and
add, remove, or edit.

DB-Library Options
 Acts as interface DLL to SQL Server.
 Included in window:
 Lists libraries and set limited options on preferences
 Information on the libraries.
 Able to change between ANSI characters to OEM.
 Set to get date/time from system, or from hardcoded
parameters.
 Need to keep aware of DB-Library values to update as server
changes are made.
 Stopped enhancements to this with server version 6.5.

Network Libraries
 Set the network libraries properties.
 View names, paths, and file information. See the DLL files.
 Allows one to see when libraries are out of date and need to
upgrading.


Some issues for people using the tool with
older OS’s. Since the tools creation the possible
actions one can take on systems has expanded
greatly.
When using the Client Network Utility to add a
new client configuration entry, which uses the
NWLink IPX/SPX network library, an invalid
port address format is allowed.

Activation of the tool:

Start  Programs  Microsoft SQL Server Client
Network Utility.

Start  Run  enter cliconfg.exe.

I hope this has been informative.