dbTalk Databases Forums  

Change dynamic port to standard 1433 per named instance

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Change dynamic port to standard 1433 per named instance in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GumbleManja
 
Posts: n/a

Default Change dynamic port to standard 1433 per named instance - 04-08-2009 , 04:13 AM






Are there any known issues if you change the SQL-TCP port from dynamic- to
the standard 1433 port in a cluster environment. We have an application wich
needs a static port in there configuration files.

What is the rule of port incrementation when we have two named instances
running in our cluster (1433 for the first instance, 1434 for the second,
...)?


Thank's a lot
Peter

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Change dynamic port to standard 1433 per named instance - 04-08-2009 , 10:15 AM






Since each instance has its own IP address, you can use the same port number
on multiple clustered instances. I have had some strangenesses with older
versions (SQL 2000) and using 1433 for a named instance so be sure and test
first.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"GumbleManja" <GumbleManja (AT) discussions (DOT) microsoft.com> wrote

Quote:
Are there any known issues if you change the SQL-TCP port from dynamic- to
the standard 1433 port in a cluster environment. We have an application
wich
needs a static port in there configuration files.

What is the rule of port incrementation when we have two named instances
running in our cluster (1433 for the first instance, 1434 for the second,
..)?


Thank's a lot
Peter


Reply With Quote
  #3  
Old   
Gotcha
 
Posts: n/a

Default RE: Change dynamic port to standard 1433 per named instance - 04-20-2009 , 02:43 AM



1434 is the SQL Browser service, don't use it for your instances.....


"GumbleManja" wrote:

Quote:
Are there any known issues if you change the SQL-TCP port from dynamic- to
the standard 1433 port in a cluster environment. We have an application wich
needs a static port in there configuration files.

What is the rule of port incrementation when we have two named instances
running in our cluster (1433 for the first instance, 1434 for the second,
..)?


Thank's a lot
Peter

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.