468,316 Members | 1,981 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Change SQL Server 2005 Express's default port programatically

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
0 2884

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Danieltbt05 | last post: by
4 posts views Thread by andreas.w.h.k. :-\) | last post: by
10 posts views Thread by amjad | last post: by
6 posts views Thread by Grey Alien | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.