Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [dac]

Dedicated Admin Console (DAC) a reserved connection on SQL Server that grants special access to system tables and can help diagnose problems

Filter by
Sorted by
Tagged with
3
votes
1answer
312 views

How do I know what requires DAC?

Playing around with SQL Server, I came across a semi-cryptic error. Essentially, I only need to log into DAC. Is there any general advice for when DAC is needed? How do I know I need it to access sys....
3
votes
1answer
1k views

How do we find who used Dedicated Admin Connection

Is there any way to find who used Dedicated Admin Connection? Not active connection but the previous one which is already closed?
2
votes
2answers
2k views

DAC connection error

I'm having a problem connecting using my dedicated admin connection in SQL Server 2014. I just wanted to test it out. I have DAC enabled in sp_configure. I have performed RECONFIGURE. I have ...
1
vote
1answer
208 views

SQL Server Error “Database 'mssqlsystemresource' does not exist.”

On Linux, whenever I run use mssqlsystemresource to get access to Resource Database, I get an error. How do I resolve this. 1> use mssqlsystemresource 2> go Msg 911, Level 16, State 1, Server ...
0
votes
1answer
5k views

Why am I getting “Invalid object name 'sys.sysobjvalues'.” [duplicate]

When I run SELECT OBJECT_DEFINITION(OBJECT_ID('sys.assembly_files')); I can see that there is a self-join on sys.sysobjvalues, but when I try to select that table I get, Msg 208, Level 16, State 1,...