Re: Network Utilities

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/11/04 

Date: Wed, 10 Nov 2004 22:55:44 -0600

Below are the relevant excerpts from the SQL Server 2000 Boons Online:

<Excerpt href="architec.chm::/8_ar_aa_27ll.htm">
The Server Network utility is used to manage the server Net-Libraries. This
utility is used to specify:

The network protocol stacks on which an instance of Microsoft® SQL ServerT
2000 listens for client requests.

The sequence in which server Net-Libraries are considered when establishing
connections from applications.

New network addresses that an instance of Microsoft SQL Server 2000 listens
on.
<//Excerpt>

<Excerpt href="architec.chm::/8_ar_aa_0qux.htm">
The Client Network utility is used to manage the client Net-Libraries and
define server alias names. It can also be used to set the default options
used by DB-Library applications.

Most users will never need to use the Client Network utility. To connect to
Microsoft® SQL ServerT 2000, users can specify only the network name of the
server on which SQL Server is running, and optionally the name of the
instance of SQL Server.

In some cases, an instance of SQL Server may be configured to listen on
alternate network addresses. If this is done, client applications connecting
to that instance must explicitly specify the alternate address. While
applications could specify the alternate addresses on each connection
request, it is easier to use the Client Network utility to set up an alias
specifying the alternate addresses. Applications can then specify the alias
name in place of the server network name in their connection requests.

<//Excerpt> 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Alan" <NOSPAMalan_pltse@yahoo.com.au> wrote in message 
news:u9uJYc6xEHA.4044@tk2msftngp13.phx.gbl...
> What are differences between SQL Server Client Network Utility
> and
> SQL Server Network Utility ?
>
>

Relevant Pages