November 11, 2008 at 6:34 am
Is it possible to setup a default instance of SQL Server 2005 to listen on multiple ports? Corporate dictates that we listen on a specific port, but we have a legacy application with a long gone legacy programmer who hard coded the 1433 port number into his code.
Simply stated, we want to listen on the corporate port and on 1433?
Thoughts?
Greg
November 11, 2008 at 7:13 am
HI Greg
Try SQL Server Configuration manager and congigure port on TCP/IP, i havent tried this, hope this works
Cheers
🙂
November 11, 2008 at 7:16 am
CrazyMan (11/11/2008)
HI GregTry SQL Server Configuration manager and congigure port on TCP/IP, i havent tried this, hope this works
Cheers
🙂
That is for one port, he wants to have the instance running on two ports at the same time
I am not sure how you would do this, perhaps set up two instances on one on each port, and add a linked server between the two..
November 11, 2008 at 7:25 am
How about using a port redirection?
Leave TCP at the default port configuration and then use a port redirection for the "corporate port".
Take a look on this third party rool:
November 12, 2008 at 6:01 am
I have accomplished this requirement by the following steps.
(1) Install a named instance and set it a static TCP port (under IP All). (for example, 4532)
(2) Configure a "default" alias to point to the named instance.
What I'm calling a "default" alias is an alias named as the server name and assigned to port 1433.
This allows you to access the instance through a number of ways.
ServerName\NamedInstance
ServerName\NamedInstance,4532
ServerName,4532
ServerName
ServerName,1433
This should cover your requirement of having the same SQL install "listen" on multiple ports. Keep in mind based on which options above you choose, you may need Shared Memory enabled as a protocol as well as the SQL Server Browser service enabled. Generally, I use the static ports only and turn the browser service off for a more secure installation.
Benjamin Lotter
http://BenjaminLotter.info/[/url]
http://www.LinkedIn.com/in/BenjaminLotter
Delight thyself also in the LORD and He shall give thee the desires of thine heart.
~Psalm 37:4
November 12, 2008 at 8:02 am
In SQL Configuration Manager simply separate the two ports with a comma. ex. 1433,xxxx. Then restart sql services.
November 12, 2008 at 3:43 pm
stacked IP addresses are another way to have SQL listen on multiple IP's and ports
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply