Gaining access to doors that are in Lockdown Mode
SQl 2012 R2
When doors are in this mode, access cannot be granted to anyone without special priviledges
To resolve this issue, the following steps need to be followed:
1. Now select the Hardware Configuration and select the Triggers and Procedures Option
2. Create a new trigger per the screen shot and save
4. Reboot the system for it to take effect and test the procedure.