SQL Server Dynamic Port change

I have a named instance which has been assigned default port 1433. I want to change this port as 1433 is default port. How do i pick up a new port number? can that be any number ? I know how to change it but what i need is what port number do i need over here? Do i need to change any fire wall rules. I have never changed any ports while i did installation, how does those ports get assigned and how do they work?

more ▼

asked Jun 06, 2017 at 11:02 AM in Default

avatar image

131 1 6 11

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

What port number do you need? That's up to you and your network guys to discuss.

Firewall rules will need to be changed, yes, as they look at traffic going in & out on various ports. The default is most likely to block traffic that doesn't match the rules provided.

more ▼

answered Jun 07, 2017 at 10:12 AM

avatar image

ThomasRushton ♦♦
42.4k 20 60 54

When I do a new installation , I have never changed any port. How is this port being assigned ?

Jun 07, 2017 at 12:09 PM rehaan

How do you know that that's the port in use?

The other thing to check is the SQL Browser service - is that running?

Jun 08, 2017 at 11:06 AM ThomasRushton ♦♦

yes sql browser service is running

Jun 08, 2017 at 02:35 PM rehaan
(comments are locked)
10|1200 characters needed characters left

Its default. To change it you have to go in sql server configuration from program > sql server 2008 or whatever > configuration tools > ... tcpip in properties > ipaddresses then at the bottom allips.change your port just watch this youtube clip, might be helpful. https://www.youtube.com/watch?v=HKfaojG7tI0

more ▼

answered Jul 13, 2017 at 08:43 AM

avatar image

101 2 8

Thank you Waqar

Aug 03, 2017 at 02:30 PM rehaan
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 06, 2017 at 11:02 AM

Seen: 91 times

Last Updated: Aug 03, 2017 at 02:30 PM

Copyright 2018 Redgate Software. Privacy Policy