instance port number

Question

instance port number

sqlfriend

SSC Guru

Points: 52769
More actions
December 3, 2012 at 4:23 pm

#265725

I have a SQl SERVER that has a default instance and a named instance.
Do I have to configure the named instance to use diffrent port than 1433 because the default instance is using 1433?
If so, do I need to go to Sql server configuration manager - network configuration - protocols- tcp/ip properties - in tcp port put 1434 there?
thanks,

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233854 More actions · Answer 1

sqlfriends (12/3/2012)
I have a SQl SERVER that has a default instance and a named instance.
Do I have to configure the named instance to use diffrent port than 1433 because the default instance is using 1433?

Yes, unless you have multiple public network adapters.

sqlfriends (12/3/2012)
If so, do I need to go to Sql server configuration manager - network configuration - protocols- tcp/ip properties - in tcp port put 1434 there?
thanks,

yes

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sqlfriend SSC Guru Points: 52769 More actions · Answer 2

Thanks,

Can I use dynamic port for the named instance,

When I install the named instance, and check the tcp\ip port, it defaults to blank, with dynamic port set to 0 which means true.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

sqlfriends (12/3/2012)
I have a SQl SERVER that has a default instance and a named instance.
Do I have to configure the named instance to use diffrent port than 1433 because the default instance is using 1433?
If so, do I need to go to Sql server configuration manager - network configuration - protocols- tcp/ip properties - in tcp port put 1434 there?
thanks,

You don't want to use 1434 for the named instance. That is the port used by the SQL Bowser service to handle dynamic ports for named instances so you don't have to assign the named instances specific ports nor use the port number when connecting to the named instance(s).

Perry Whittle SSC Guru Points: 233854 More actions · Answer 4

Oops good catch Lynn I didn't spot that port number there

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Perry Whittle SSC Guru Points: 233854 More actions · Answer 5

sqlfriends (12/3/2012)
Thanks,
Can I use dynamic port for the named instance,
When I install the named instance, and check the tcp\ip port, it defaults to blank, with dynamic port set to 0 which means true.

When you open the tcpip properties you have an assignment for each NIC found on the server and an IPAll section. When it's set to dynamic the dynamic field should show the currently assigned port.

You must use a port other than 1433 or 1434 and also ensure the port is not already in use by another app.

In the same location as the HOSTS file on the server is a SERVICES file. Check in here for currently assigned ports and pick a port number that isn't listed.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sqlfriend SSC Guru Points: 52769 More actions · Answer 6

Thanks both. that is helpful.

We are trying to install servers for system center management.

it doesnot support dynmic ports.

But it has to have multiple instances.

So following your instruction, I think I will use a port like 5033

Thanks