UDP port change - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

UDP port change

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-05-21 : 18:01:29

Is it possible to change the UDP port for SQL Server? I know the deault port for UDP is 1434 , I am wondering if it is possible to change the UDP port or not?

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-21 : 18:37:30

I googled for it, and it doesn't look like it can be changed.

But why do people even need this? Just create an alias instead!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

influent
Constraint Violating Yak Guru

367 Posts

Posted - 2009-05-21 : 18:39:39

I believe this is true:
"You cannot change the UDP port from 1434 to another"
http://vsql.blogspot.com/2004/06/what-udp-port-does-sql-server-listen.html

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-05-21 : 20:18:06

quote:
Originally posted by tkizer
But why do people even need this? Just create an alias instead!

I think UDP can not be changed (like FTP 21 and HTTP 80).
Thank you Tara and influent.

Tara, I kind of got your alias solution. Looks like it will work for me. I have a firewall and named instance that need to be accessed.

Is there a way to do the alias name by scripting? (I have many servers) I hope there would be a registry key; which i can update.

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-22 : 16:05:08

Since the alias is stored in the registry, you can easily script it by creating a reg file. You can have regedit.exe create the reg file for you via the export option in the file menu.

Here's where aliases are stored:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-22 : 16:05:41

And then to import the aliases, the user can either double click on the provided reg file, or import it via import option in the file men of regedit.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-05-22 : 16:13:16

Thank you Tara,

I am thinking of using xp_regwrite and xp_regread.

The other option is to as you said to use a .reg file and double click. Is this a good option? I have never used it.

1. what happens if a person double clicks more than once?
2. What happens if the registry value already exist; does registry value gets updated or ignored?
3. Can I call .reg file from a batch file?

------------------------
I think, therefore I am - Rene Descartes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources