Wednesday, March 28, 2012

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.

No comments:

Post a Comment