Connecting Tech Pros Worldwide Forums | Help | Site Map

Change SQL Server 2005 Express's default port programatically

DL
Guest
 
Posts: n/a
#1: Oct 14 '08

I'm wondering if there's some t-sql code that can reset sql server
2005 express's TCP dynamic port from default {1037} or the like to
blank and TCP Port to {1434} or the like.

Ok, microsoft site has the following info about server network
configuration,

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<MSSQL.x>
\MSSQLServer\SuperSocketNetLib\Tcp\IPAll

Now, question, what's the xp or evn sp for resetting registry value
for the above?

Thanks.
Closed Thread