开发者

How do I enable DAC on a clustered SQL Server 2008 after I can no longer connect to SQL Server in any other way

开发者 https://www.devze.com 2023-01-27 15:00 出处:网络
I\'m having issues with SQLServer 2开发者_运维技巧008 where a Server level triggered was not dropped correctly.

I'm having issues with SQLServer 2开发者_运维技巧008 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


According to this article the only other alternative to drop these triggers is to stop your server and restart it using the minimal configuration mode. You can obviously then enable the DAC.

0

精彩评论

暂无评论...
验证码 换一张
取 消