G’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter of course on all of my SQL instance as I manage most of them remotly.
However, from time to time I discover instances that have had remote admin connections disabled by another DBA.
So now I make it part of my regular checks to ensure that the DAC connection is available remotely - should I ever need it
Now, I’ve not had cause to use the DAC to troubleshoot a problem myself, but should I ever want it, then I’d expect it to available and it would be a cause of come concern and annoyance were it now.
So, a simple check from time to time to ensure that this connections is still available is appropraite.
I’d encourage others to do the same – should you have remote admin connections turned on.
Have a nice day.
cheers
Martin.