Dynamic and Static Ports

• sociald

  Newbie

  Points: 1

  More actions

  May 1, 2014 at 8:40 am

  #306949

  Good Morning! I have been trying to get our SQL servers organized at work and one thing I am doing is setting up a Central Management Server. Although I am familiar with SQL I am just getting more in learning the DBA side.

  So as I was registering all these servers and I see that many are using dynamic ports and browser services is not running. So I am not able register those services.

  So what would be my best options in terms of security.

  Enable browser services or set a static port.

  I would imagine that since browser services isn't running and its a dynamic port that it shouldn't affect any applications running moving to a dynamic port.

  I will have to test on some servers that are less critical first. But some of these run important applications that keep a hospital running. And security is top concern.

  Its just that the management of all these servers has got out of control.