edit server network library configuration
-
Is it possible to edit the "server network library configuration" without going to
"Start menu, point to Programs/Microsoft SQL Server, and then click Server Network Utility"?
I am trying to change the port number from 1433 to something else for MSDE.
Thanks in advance
Billy
-
Not to sure about MSDE.
The EXE's for the connection utilities are usually stored in c:\winnt\system32. Look for something called svrconfg.exe, or srvconfg.exe
Failing that, you can always edit the registry. Look for something like the following,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
On my machine it is C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Jay Madren
Jay Madren -
Phill, that key is actually for your computer as a client to SQL Server instances. The key that controls which port SQL Server listens on is this (you need to change instance name to what name you have for your instance):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE_NAME\MSSQLServer\SuperSocketNetLib\Tcp
Change the value for TcpPort to whatever you want. Note that this info is for SQL Server Developer Edition that I have installed on my computer, not sure if it differs for MSDE.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply