By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

Change SQL Server 2005 Express's default port programatically

P: n/a
DL

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.
Oct 14 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.