Change SQL Server 2005 Express's default port programatically

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • DL

    #1

    Change SQL Server 2005 Express's default port programatically


    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_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL Server\<MSSQL.x >
    \MSSQLServer\Su perSocketNetLib \Tcp\IPAll

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

    Thanks.
Working...