Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm having issues with SQLServer 2008 where a Server level triggered was not dropped correctly.

Articles on the web recommend dropping them through the DAC.

However, the DAC is disabled by default on Clustered environments.

How do I enable the DAC bearing in mind that I can no longer connect to the SQLServer 2008 instance in any other way.

cheers

andy

share|improve this question

1 Answer 1

To enable DAC, you need to run the following SQL command against your server:

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

If you can't connect to it to even run this though, you will most likely need to start your server in single-user mode (or possibly minimal configuration mode) and go from there. To do this, you stop your SQL Server, then run it from the command line with either the -m option (single-user mode) or the -f option (minimal configuration mode, which also enables single-user mode). You should be able to drop the triggers from there, or enable DAC from there, whichever you are more comfortable with.

sqlserver command line reference
single user mode reference

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.