SharePoint Thoughts

So I kept running into this error on the SQL Server that I was working on, it kept filling up the SQL Server Logs as well as the Application Event Logs. I spent over an hour trying to find out what the problem was, I changed all the account information for the services that had that account as a services identity. I made sure the account was a server administrator, I made sure that the account was in the sysadmin role on the SQL Server, but alas none of this worked.  

What happened when I turned on SQL Server Profiler, was that I noticed the SQL Agent was trying to run jobs associated with two non existing Shared Service Providers. I had modified/deleted several service providers setting up the server initially, and these jobs get deleted along with their associated SSPs. Once I deleted these two jobs, the failed logins stopped. I hope this is helpful if you ever run into this error.