Login failed for user login due to trigger trigger

Question

I accidentally get this error on the asp.net web application that I deployed. I do not use triggers in the database, so I'm not sure what to do. This happened on the weekend when no one was in the application, it just happened by accident. Please help, this is critical.

This is the first time I get an 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

Logon failure is generated at the server level, not at the database level.

That is, you may have a LOGON trigger . You would check it at sys.server_triggers .

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

Answer 2

You can double check for triggers with:

 use YourDb select * from sys.objects where type = 'TR' 

EDIT: this is like an ASP.NET membership that ends in a user database (this is not a SQL Server login). Can you see which connection string the ASP.NET membership provider uses? This is usually in Web.config, for example:

 <providers> <add name="AspNetSqlMembershipProvider" ... connectionStringName="<<connection string>>"