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

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
25 views

DAC silently swallows tokenization errors in sp_msforeachdb

This morning I hopped on the DAC to check something out. Oops, I made a typo! 1> exec sp_msforeachdb N' 2~ use [?] 3~ select N'?', count(*) from sys.sysrscols; 4~ ' 5> go 1> Can you spot ...
2
votes
0answers
686 views

Severity 20 Error upon disconnecting Dedicated Administrator Connection

Starting working with Dedicated Administrator Connections on SQL Server 2008 R2 servers. All is working fine (once port 1434 was opened), but am getting severity 20 errors when I disconnect the admin ...
1
vote
0answers
48 views

How many connections does Object Explorer use in SSMS?

I recently enabled DAC and noticed this error when first trying to connect with object explorer in SSMS: Cannot connect to admin:servername Dedicated administrator connections are not ...
0
votes
0answers
10 views

Data Warehouse Administration Console (DAC) server not starting

I have installed the dac client and able to login to dac client but server not starting error that i am getting, please look at the screenshot of the error below.
0
votes
2answers
38 views

SQL server DAC connection to mssqlsystemresource database

I have a problem while connecting to the mssqlsystemresource database. When I try to connect with DAC connection (without restarting SQL server with -m option) it works, but I can't use the ...
0
votes
0answers
44 views

SQL Server DAC - Connection Issue

I am having a strange issue when trying to connect to my SQL Server instance remotely from my client computer. I am able to do this on my other instances by opening up a new Database Engine Query and ...