John Rowan (1/20/2010)

---

Do you mean that your NumberofDays calc needs to test for OpenDate being NULL?

If so, use COALESCE. Since you have not specified where that second date column comes...

yes, as soon I stopped the dundas service that connects to SQL, the error stopped, once I started it up again, the error started again.

[bump]

I found the issue, it was a Dundas Service that someone installed and was running on the web server that was using the wrong ID and PWD.

I'm at a loss myself with this. I've stopped IIS, stopped all sites, stopped all web related services on my web server in general, but yet it's still happening. This...

the message in the event viewer?

(i had a moment)

here is what is right before the login error happens:

2010-01-07 00:02:48.46 spid51 Using 'xpsqlbot.dll' version '2005.90.3042' to...

did that, as well as a sql trace and that didn't show me anything out of the ordinary. All of the ID's were coming from web sites on a different...

did that as well as stopping all of the web sites and the error is still popping up on my db server

the error is appearing every minute to the second

OK, however, I shut down all of the web sites on my web server and the error is still popping up.

Yes

just an FYI, I resolved this issue with my 3 db's not being backed up and the back up job failing. The suggestions that were provided were good, but didn't...

No and it hasn't in the 2 years that I've been here. Its running under a domain service account. One of the databases is 2 years old and has been...

yes it is, and its driving me nuts because its only 3 of my db's and only on my dev and qa servers, these same 3 databases on my prod...

I read your second recommendation prior to posting, and it didn't resolve anything. If anything that led me to more questions such as, if that was the case, then why...

At the time of the backup there is nothing running due to I reset the SQL Server at 1:00 am to make sure no one is connected to any databases,...

the databases are being backed up to a 800 gb drive with 200 gb of free space on a nightly basis and the db's themselves are a total of 10...