We've taken similar approach but one step further.  Convinced the enterprise to give us a dedicated server then via powershell reach out to each of our SQL instances, get list...

Thanks for the input.  I've gotten a workaround in place, but not was hoping there was a better solution.
Currently I created a custom server level role that includes db_creator...

Sorry....meant "bogus" as in "expletive of frustration"

This is part of a cluster with two other instances. The other two instances are not on the node that matches the IP...

No linked server (or other server objects)

No maintenance plans

Only handful of jobs that always run successful

No local windows tasks I can find

Entries are hitting the log anywhere from 20-120 seconds,...

Ran the trace and even more confused now.

EventClass - Audit Login Failed

TextData - Login failed for user 'foo'. Reason: Password did not match that for the login provided. [CLIENT: 123.45.67.89]

ApplicationName...

Thanks but that doesn't answer my question. The account is being successfully used by the application and I can use it to connect directly to SSMS. I know...

That doesn't explain how the report can run for over a year without issue, suddenly jump in time and stay at the longer time until SSRS is restarted. As...

ReportServer.dbo.Subscriptions enddate value is null for whole table

msdb..sysschedules active_end_date is '99991231' for whole table

Nope. New subsciptions with new schedules.

I've always done my initial restore of the bak manually (in NORECOVERY) and just point logshipping to use my database_new when applying logs.

I think your issue is with...

Not saying this is the smoothest code, but it works pretty well. You will need to have xp_cmdshell enabled on the machine you are running this from, but you...