Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Expand / Collapse
Author
Message
Posted Friday, May 7, 2010 5:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 3, 2014 1:58 AM
Points: 312, Visits: 533
Hi Experts,

i dnt have any trigger created on master database but still i m getting this error.

There is only 4 default database on the server.

I m getting the following error.

Logon failed for login ‘Sa’ due to trigger execution.
Changed database context to ‘master’.
Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)
Post #917807
Posted Friday, May 7, 2010 5:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
Check for the existance of a logon trigger

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Post #917819
Posted Tuesday, May 11, 2010 3:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 3, 2014 1:58 AM
Points: 312, Visits: 533
Not found as there is no trigger in any database
Post #919551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse