Tag: Dedicated Admin Connection

  • Who Has The DAC?: Or How I Found Out I Had The Dedicated Admin Connection On SQL Server

    Here’s a quick little snippet of T-SQL script that will hopefully prove handy to someone (and that I’ll end up googling at some point and find my own blog post). Are you trying to determine who is currently using the dedicated admin connection (aka DAC) on a particular SQL Server? Did SSMS give you a […]

  • Error when trying to use DAC connection in SQL Server

    So, one of my local databases got stuck in single-user mode. Easy solution? Connect to my instance using SQL Server’s Dedicated Admin Connection (aka DAC) and flip the database back to multi-user. Easy! Wait. What? TITLE: Connect to Database Engine —————————— Cannot connect to ADMIN:localhost\SQL2012. —————————— ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while […]