Curt Stone 6.May.09 11:35 AM a Web browser LEILEI - 6.5Windows
We get this error "SQL Server does not exist or access denied" in our log intermittently from a replication job Notes to SQL Server. This job ran fine all last week. Last couple of days, error occurs again. We've had this issue off and on for a while now. We run the job from administrator during the day untill it will finish successfully. We've changed the schedule a couple times but it always seems to reoccur. We have two other replication jobs using the exact same SQL Server connection doc and no issues with them. They run like clock work.
Interesting too is that the log states that the job ran for approx. 2 minutes and updated 1900 records each time this fails. The error message is obviously very confusing if there's no server or access denied if the log says it was successful for a brief 2 minutes.
Out of ideas.... Any idea what we can try?
Thanks.