How to Use Dedicated Administrator Connection in SQL Server

How to Use Dedicated Administrator Connection in SQL Server

In this post we will explain How to Use Dedicated Administrator Connection in SQL Server.Microsoft SQL Server provides a dedicated administrator connection (DAC). The DAC allows an administrator to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client connections. The DAC is available through the sqlcmd utility and SQL Server Management Studio. The connection is only allowed from a client running on the server. No network connections are permitted.

Using SQL Server Management Studio:

Connect to Database Engine dialog box, in the Server name box, type ADMIN: followed by the name of the server instance. For example, to connect to a server instance named ACCOUNT, type ADMIN:ACCOUNT.

Using SQLCMD:

Default Instance

SQLCMD –S [ServerName] –U [UserName] –P [Password] –A

Named Instance

SQLCMD –S [ServerName\InstanceName] –U [UserName] –P [Password] –A