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… Continue reading Who Has The DAC?: Or How I Found Out I Had The Dedicated Admin Connection On SQL Server

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… Continue reading Error when trying to use DAC connection in SQL Server