http://www.sqlservercentral.com/blogs/brian_kelley/2008/11/20/mssqltips-com-connecting-to-sql-server-with-a-bad-logon-trigger/

Printed 2014/09/02 07:21AM

MSSQLTips.com: Connecting to SQL Server with a Bad Logon Trigger

2008/11/20

Shortly after I gave my presentation Trigger Happy Database Security down in Jacksonville for SQL Saturday #3, I received an email asking how to recover from a bad logon trigger that was blocking access to a SQL Server. The answer is to use the DAC, as I describe here:

 Connecting to SQL Server with a Bad Logon Trigger

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.