Showing posts with label utility. Show all posts
Showing posts with label utility. Show all posts

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.

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