http://www.sqlservercentral.com/blogs/martin_catherall/2012/03/31/remote-dac-connections/

Printed 2014/11/26 04:14AM

Remote DAC connections

2012/03/31

Tweet

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.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.