SQL Server 2005 - Changing Port in Cluster Environment
-
I have setup an Active Passive Cluster in SQL Server 2005. For security issue we wanted to change the port from default 1433 to 1456. In SQL Server 2000 it was pretty straight forward but it looks complicated in SQL Server 2005. If anyone has done anything in it please help. Attached is the screenshot of SQL Server Configuration Manager. My question is do I replace 1433 with 1456 WHERE IT APPEARS (it appears at 5 places) or I have to change it ONLY WHERE IT SAYS IPALL. Also, there is a second screen shot of VIA properties. Even though that's disabled should I replace 1433 with 1456 overthere too or not? Any help will be greatly appreciated...
-
I cannot see your screenshot, but here's how it works with an active/active cluster (x64).
I just testted it today.
SQL server configuration manager \ SQL server 2005 Network Configuration
protocol name TCP/IP tab IP Addresses section IPAll.
Change the TCP Dynamic Ports (which contains a fixed port for your instance which was determined dynamicaly) (all other TCP Dynamic Ports have 0 )
O darn, you've probably installed a default instance (MSSqlserver) which has a fixed address 1433.
I guess then you'll have to change them all, or choose them to be dynamic (0) and only provide the IPAll with the correct one.
I'll test the last scenario in a moment
and keep you informed.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
altering the IPAll port, will have only that port active for connections when working with fixed ports.
(just done a quick test)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks for your reply... I think you are right IPAll will have only that port active for connection when working with Fixed ports ASSUMING that we will have Enabled set to No for all the IP addresses. What do you say?
-
I have altered the IPAll port, and even enabled the instance's own ipaddress with another port, but connecting using the latter ipaddress/port did not work !
Connecting using the ipaddress/"IPAll-port" worked fine.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I got you, thanks for your help.. By the way I just got a reply from a MVP on Microsoft's website too which is:
"If Listen All is set to No on the Protocol tab, you need to set the port for
each IP address. If Listen All is set to Yes, you only need to set the port
for IPAll."
-
thanks for the feedback.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
yup yup that right mister A MALIK
:crazy: :alien:
Umar Iqbal
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply