Question

What is dedicated administrator connection(DAC)?

Answer

SQL Server provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.

This dedicated administrator connection (DAC) supports encryption and other security features of SQL Server. The DAC only allows changing the user context to another admin user.

Read More..   [39 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  ·