How to do change sql default port number without any disruption on sql server

SQL Server Administration
1

Hi All

Please guide me on how to do change sql server default pot number on sql server.

Thanks & Regards

Kandavel U

2

What are you trying to solve?

3

hope this helps

4

@harishgg1 remember he said "without disruption"

5

Maybe .. using T-SQL as admin ..with commands .. possibly 10 seconds latency

6

what about applications/systems downstream that use the sql server ? changing it might be 10 seconds but the result might be catastrophic for systems that use the sql server.

7

have to do ALL THOSE standard stuff

  • impact analysis is one
1 Like