Enable Dedicated Administrator Connection in SQL Server 2012

Introduction Microsoft introduced Dedicated Administrator Connection (DAC) feature in SQL Server 2005. Using DAC feature a database administrator can connect to an SQL Server Instance when SQL Server stops responding to normal connections. During such scenarios using DAC feature a DBA can connect to the instance to troubleshoot and kill processes which are causing issues. […]

Read More »