Post reply

Changing SQL Port from Dynamic to Static

  • November 22, 2019 at 9:57 am

    #3699928

    If I have been asked to change the SQL Server port from Dynamic to Static and this is all that I am doing, is a Service restart needed?

  • November 22, 2019 at 10:00 am

    #3699930

    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

  • November 22, 2019 at 10:54 am

    #3699955

    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.

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

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