I do run a sql server light 2014 version..
and after reboot somtimes dynamic port tcp is changing..
so i have to add that new port into firewall incoming rules to let sql server clients work again and
gain access to the server machine through the firewall.
my questions are:
- is there any possibility to prevent this behaviour of changing daynmic ports in reboot?
- is there any chance to log the current and old port into a logfile on desktop by scripting or so?
- is there maybe a chance if happens.. to let the new port number directly let update firewall and
give the new port number there without interactions?
all clients are windows 10 clients and sql machine too.
thx for help, bernd