Enabling the Dedicated Administrator Connection in SQL Server

24 06 2011

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. The DAC also allows you to query the system base tables you don’t normally have access to. To connect using the DAC, prefix the instance name with “admin:”.

Here are the runes to enable it:

sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
Advertisements

Actions

Information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: