I can't login on the server giving error: 17892.
I want to drop the trigger but , as soon as I tried to login, the trigger(Tr_ServerLogon) get executed
and login failed.
CREATE TRIGGER Tr_ServerLogon
ON ALL SERVER FOR LOGON
AS
BEGIN
INSERT INTO AuditDb.dbo.ServerLogonHistory
SELECT SYSTEM_USER,USER,@@SPID,GETDATE()
END
GO
/*Where 'Tr_ServerLogon' is trigger name */
/* AuditDb the database name which I have created. */
I have used following link with mine credentials but failed .
Here I am using SQL Authentication to logon to the server.
http://mssqlonline.blogspot.com/2009/06/sql-server-fix-error-17892-logon-failed.html
Can anybody suggest me the solution?