Connecting Tech Pros Worldwide Help | Site Map

Change SQL Server 2005 Express's default port programatically

  #1  
Old October 14th, 2008, 05:15 AM
DL
Guest
 
Posts: n/a

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