I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

SQL Server 2005 Dedicated Administrator Connection

Since i've started playing with SQL Server 2005 i've come accross a few things that i think are very cool.

I write them here so i don't forget about them :))

One of them is a Dedicated Administrator Connection (DAC)

This is a special diagnostic connection which is used by DBA's to troubleshoot a server when the server is refusing other connections

for whatever reason.

DAC can be created with SqlCmd utility or in SSMS with admin:instance_name.

Also only one DAC is allowed per instance.

Remote network access must be enabled with SQL Server Surface Area Configuration

 

I think this is a very handy and usefull novelty.

 

You can find more info about DAC here.

 

Print | posted on Monday, February 19, 2007 9:18 PM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: SQL Server 2005 Dedicated Administrator Connection

i want information about SQL Server 2005 Dedicated Administrator Connection.
5/14/2008 9:17 AM | abbas
Gravatar

# re: SQL Server 2005 Dedicated Administrator Connection

i want information about SQL Server 2005 Dedicated Administrator Connection.
5/14/2008 9:17 AM | abbas
Gravatar

# re: SQL Server 2005 Dedicated Administrator Connection

i want to have sql server in DAC mode. but for enabling remote DAC, i can't see the option in sql server surface area configuration. What could be the reason? i using sql server 2005
6/12/2008 6:48 AM | suki
Gravatar

# re: SQL Server 2005 Dedicated Administrator Connection

Hi Suki. Did you check both surface area configuration for connections and features? there must be DAC node under sql server service (as far as I remember)
2/3/2009 8:39 PM | DAC
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET