Post reply

DAC disabled and Logon trigger blocking Access

  • January 12, 2024 at 8:22 am

    #4360654

    Hi Experts,

    I'm encountering an issue with DAC being disabled and a logon trigger blocking access to the server. What are the available options for accessing the server and disabling the login trigger?

     

    TIA

  • January 12, 2024 at 8:46 am

    #4360657

    Try to start SQL in single user mode, IIRC that would disable the logon trigger and allow you to drop it, to start in normal mode and resume operation.

  • January 16, 2024 at 12:42 pm

    #4362625

    Ant-Green wrote:

    Try to start SQL in single user mode, IIRC that would disable the logon trigger and allow you to drop it, to start in normal mode and resume operation.

    Thanks @Ant-Green. Single user didnt help. Able to resolve the issue from another login.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply