Changing SQL Port from Dynamic to Static

Question

Changing SQL Port from Dynamic to Static

Viewing 2 posts - 1 through 3 (of 3 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

If you change the port to a different one from that which it's using currently, then yes, you'll need to restart. If you plan to keep using the same port, you don't really need to restart - although you may want to anyway, just to check that it works in its new configuration.

John

garryha SSC-Addicted Points: 435 More actions · Answer 2

Thanks, I am planning to keep the port number the same.

I ask because a certain team want the port changed to static to upgrade a programme that needs it to be static. If I can just change it without the restart of SQL that would be great as if I have to restart SQL there is a whole load of red tape to go through and it would take days/weeks to get it done instead of minuets in the case of not needing a restart.