Net-Lib Question

Hi,
In the Server Network Utility (sql server 2000), if I do not select or enabl
e any net-libs such as TCP/IP, Names Pipes, Multiprotocol in the server, use
rs from client machine will still be able to connect to the server? How is t
his possible?
When the client is connecting to the server, which is the default network pr
otocol it uses and can it be changed?
Also If I want to clients to use Multiprotocol net-lib to connect to the ser
ver, what are the configurations I need to make both at the server and clien
t?
One more question is; If I have 2 instances of sql server 2000 on the same
machine, on the named instance, in server network utility, I Cannot see Mult
iprotol net-lib, any idea why?
Thanks
GYKThere is not default server side net library.
Multiprotocol cannot be enabled on a named instance. See the CLient and
Network Net-Libraries topic in Books on Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Net-Lib Question

Hi,
In the Server Network Utility (sql server 2000), if I do not select or enable any net-libs such as TCP/IP, Names Pipes, Multiprotocol in the server, users from client machine will still be able to connect to the server? How is this possible?
When the client is connecting to the server, which is the default network protocol it uses and can it be changed?
Also If I want to clients to use Multiprotocol net-lib to connect to the server, what are the configurations I need to make both at the server and client?
One more question is; If I have 2 instances of sql server 2000 on the same machine, on the named instance, in server network utility, I Cannot see Multiprotol net-lib, any idea why?
Thanks
GYKThere is not default server side net library.
Multiprotocol cannot be enabled on a named instance. See the CLient and
Network Net-Libraries topic in Books on Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql

Need your advice on SQL2000 and WINS

Hi all,
We have windows 2003 active directory. With SQL server,should we
configure the WIN server to achieve performance on the TCP/IP of
adaper settings? What about NetBIOS settings? Should we check the
default or enable Netbios over TCP/IP?
Thank you.Hi John
You should not need a wins server resolution should be through the DNS. For
security only use the protocols that are needed.
John
"John" wrote:
> Hi all,
> We have windows 2003 active directory. With SQL server,should we
> configure the WIN server to achieve performance on the TCP/IP of
> adaper settings? What about NetBIOS settings? Should we check the
> default or enable Netbios over TCP/IP?
> Thank you.