Logon failed for login 'user' due to trigger execution

Question

I am getting this error randomly on an asp.net web application I have deployed. I am not using any triggers in the database so I am not sure what to do. This came up over the weekend when no one was in the application, it just randomly happened. Please help this is mission critical

This is the first instance of where I get the error:

  public static Guid LoginUser
    {
        get
        {
            Guid g = new Guid();
            MembershipUser m = Membership.GetUser();
            if (m != null)
                g = (Guid)m.ProviderUserKey;

            return g;
        }
    }

Answer 1

Login failed comes is generated at the server level, not the database level.

That is, you may have a LOGON trigger. You'd check for this in sys.server_triggers.

Now, there is at least one known issue described on MS Connect as well as some investigation+potential fix by Pinal Dave (YMMV)