Home Forums SQL Server 2008 T-SQL (SS2K8) SQL Server Logon Trigger Problems RE: SQL Server Logon Trigger Problems

  • March 20, 2013 at 12:55 pm

    #1599084

    this error:

    The check for encryption trigger fails with the infamous ‘login fails due to trigger execution’ error when using any .Net app (SSIS, SSRS, VB program, etc.).

    is normal for a login trigger;

    the connecting user cannot get any custom error message raised by the trigger...that error goes into the SQL log, but not to the connecting user.

    they get stopped, but it might not be obvious what the error was.

    some issues might be raised because you are using tables the connecting user has no access to at all: ie the specific table (DatabaseLogonAudit.dbo.AuditDatabase) ; and maybe some of the sys views the end user might not have access to: you might need to grant SELECT ON DatabaseLogonAudit.dbo.AuditDatabase to public to fix that issue.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!