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?
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.
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.