Hi all,
We implemented new SQL Server 2008 R2 database servers as part of our Tessitura v11 project. During that process, I started monitoring some things we hadn't really paid close attention to before. One of those things related to some of the SQL Server errors, particularly severity levels of 016 through 025.
I noticed that we periodically receive severity 020 errors that look like this:
DATE/TIME: 8/23/2012 7:49:02 PM
DESCRIPTION: Logon failed for login 'webapi' due to trigger execution. [CLIENT: ###.###.###.###]
COMMENT: (None)
JOB RUN: (None)
Webapi is one of web users. These only seem to occur in the context of SOAP API usage.
I haven't received reports of any problems so it could be a situation where the service tries again after a failure like this, but I'd like to track it down if possible. Have any of you run into this type of error before?
Thanks!David