[SQL] Logon failed for login 'user' due to trigger execution

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;
}
}

Continue reading...