Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My SQL Server just died due to a DAC connection being established. I need to find out how/who or what caused this connection? Is this logged anywhere? Can anyone shine any light on this?

share|improve this question
1  
How have you established that (a) a DAC connection was established and (b) that caused it to "die"? And what do you mean by "it died" anyway? –  Martin Smith Jan 16 '13 at 12:29
    
It appeared in the error log in Event Viewer. And by died, I mean it stopped responding to everything. All of the applications stopped working because they couldn't get connected to the box. A restart of the server was the result. –  Neil Knight Jan 16 '13 at 13:39
    
So is it not possible/more likely that someone logged in using the DAC to investigate the performance issue as they could not get a connection any other way rather than the logging in via the DAC actually causing a problem (never heard of anything like that). The performance issue might have been a large blocking chain meaning no free workers available. –  Martin Smith Jan 16 '13 at 13:42
    
It happened 6 seconds after an Windows Service was started up. This Windows Service has no relation or permission to log in to SQL via DAC. –  Neil Knight Jan 16 '13 at 13:49
1  
I still don't see how you've jumped to the conclusion that the DAC caused the problem. –  Aaron Bertrand Jan 16 '13 at 15:31
show 1 more comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.