SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Remote DAC connections


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.




Leave a comment on the original post [martincatherall.com, opens in a new window]

Loading comments...