Client
Network Utility: Configure MSDE protocols
 The Client Network Utility is a configuration tool that tells ADO which
network protocols to use when connecting to SQL Server and MSDE. The utility
can be very useful especially if the network connectivity is limited to
certain protocols, like TCP/IP when connecting to the Internet.
Compare & synchronize SQL Server schemas & data
Tune slow SQL Server code and eliminate blocks and
deadlocks
Import & export SQL Server data (CSV, Excel, XML, HTML)
Schedule SQL Server jobs with e-mail alerts
SQL Server installation, creates a shortcut for the Client Network Utility
in the Microsoft SQL Server group in the Start menu. The MSDE installation on
the other hand, does not create the shortcut leading many to believe that the
Client Network Utility does not ship with MSDE. As a matter of fact, The
utility is part of the Microsoft Data Access Components that ship with Windows
and can be downloaded from the Microsoft Website.
You can use The Client Network Utility to configure the protocols you wish
to support. You can also create aliases that can act like server names. All
aliases created in the Client Network Utility can be registered in
Teratrax
Database Manager and accessed like any other server name.
To open the Client Network Utility:
Click on Start->Run and type cliconfg.exe then
click OK.
If you have an earlier MDAC version, you can download MDAC 2.8 directly
from Mirosoft:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
|
