Wowser!

Thanks very much I'll give it a go.

Thanks

Hi to all respondents

I'm flattered that I'm still getting responses to threads associated with my original post from December 31, 2009!

This is a great forum - thanks!

Yes, Windows Integrated Security in the datasource.

No replies can only mean 4 things ...

1. I'm in the wrong Forum!

2. I didn't describe my issue clearly

3. My server configuration is not typical and people are not familiar...

Thanks very much to all who took the trouble to reply. We have now got to the bottom of our problem.

Someone in the past has inadvertently (naively and by...

Thanks Steve and Jeffrey

We looked into proxies and got the desired result by leaving the agent service logon alone and changing the steps in the scheduled job to run as...

Steve

thanks for that tip. I'll try it.

Len

Steve

Agent definitely works with the LocalSystem account - this is how we have had it set up from the start and it works fine however with this account we...

Sorry I never answered your question fully - this is a couple of entries from the server security log at the time

Also we have tried other domain accounts and get...

This is the recent SQL Server Agent log covering the time from stopping the service with the Local System account as logon and attempting to change to the new account

Date,Source,Severity,Message

10/25/2010...

Hi

I spent a while at the time trying to follow the previous posts on this topic and unfrotunately still cannot get an answer to my problem. The original...

Yes I can run the SP locally and I am sysadmin on both servers.

Thanks for getting back so quickly. I don't want to go down the web devp route just yet and I'm exploring other potential solutions.

Thanks

Thanks for the tip. I'll try it again and reboot twice as you have suggested. The domain account I'm trying to use is set up as a service...

I'm flattered that my post has generated so many replies but alas I'm no nearer a solution. I have read some of the articles and I'm wondering whether it's...