Improve company productivity with a Business Account.Sign Up

x
?
Solved

SQL Cluster Port# Change

Posted on 2009-05-07
1
Medium Priority
?
624 Views
Last Modified: 2012-08-13
We are running SQL 2005 Failover cluster with 2 active nodes and 1 passive.  The active nodes have a default instance and 2 named instances on one active Node and 3 named instances on the other active Node.   I noticed that in addition to the default intance running on 1433 (which is the 'default' for a default instance), 3 other instances have been set up use static port of 1433.  Should the named instances be using port 1433?   I need to modify another named instance to a static port #... what port numbers should I be using?  Should I use 1433 again?  Thank you.


0
Comment
Question by:sqlnewbie08
1 Comment
 
LVL 9

Accepted Solution

by:
ezraa earned 2000 total points
ID: 24329879
It does not matter.  You can use which ever port you want.  

I would recommend using a different port number just so that you have more control (you can connect to the instance without the instance name: server,port).

Setting the port to something other than 1433 can be useful for security reasons (having a firewall only allow traffic from certain address to a specific SQL instance) or for connecting with legacy programs that don't connect to a named instance properly.  

0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question