Why do I need DAC if I am able to connect to the server via sqlcmd? RRS feed

  • Question

  • DAC attracted my attention at the moment when I was unable to connect to the SQL Server using a traditional way (the reason was deleting logon trigger). I made some searches on the web and it turned out that the only way to access the Server was to use DAC connection which unfortunately was turned off by default. However, I was able to overcome the problem (I removed trigger) using just sqlcmd.

    My question is if I can connect to the SQL Server just using sqlcmd, what is the purpose of DAC then?

    Monday, December 2, 2019 1:29 PM


All replies