MSDE 2000 on a Windows 2000 machine

After I install MSDE on a windows 2000 machine I enable the network
protocols stop and start the server and everything works fine. When I
try to disable the network protocols I stop and start the server and it
doesn't work. I have to run SVRNETCN to see that the TCP/IP and Named
Pipes are disabled. I click ok and it tells me that the server has to
stopped and started for the changes to take effect. I stop and start
the server and the changes are in effect. Any way that I can set the
changes without having to run SVRNETCN
Thanks
hi,
johndoe17@.verizon.net wrote:
> After I install MSDE on a windows 2000 machine I enable the network
> protocols stop and start the server and everything works fine. When I
> try to disable the network protocols I stop and start the server and
> it doesn't work. I have to run SVRNETCN to see that the TCP/IP and
> Named Pipes are disabled. I click ok and it tells me that the server
> has to stopped and started for the changes to take effect. I stop
> and start the server and the changes are in effect. Any way that I
> can set the changes without having to run SVRNETCN
AFAIK the Server Network Utility writes all the necessary registry entries
to perform the network protocols changes.. you should be able to do the same
"simply" assigning the
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Su perSocketNetLib
ProtocolList = ....
registry value, but this does not seems to work, so I do think svrnetcn.exe
performs further writes...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Is there a command line option I can use to run svrnetcn without the
user interface, so that I can tell it which server to set the protocols
for?
|||hi,
johndoe17@.verizon.net wrote:
> Is there a command line option I can use to run svrnetcn without the
> user interface, so that I can tell it which server to set the
> protocols for?
perhaps via WMI, but never tried it out...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for all your help. I was able to change the value in the
registry key
"HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\S uperSocketNetLib
ProtocolList = " to 0 and everything seems to be disabled.
Thanks again.
sql