Remote DAC connections

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.

About Martin Catherall

Martin Catherall is an SQL SERVER DBA working in Christchurch on the south island of New Zealand. He likes learning interesting stuff about databases and passing on his knowledge. In his spare time he likes to learn guitar and hang out with his young son Callum Glen.