I am pretty sure that Infrastructure do keep a log file and there is nothing in there of any note; we did check this. However I am working remotely...

The servers are not clustered.

It seems to start once the TSM backup starts. This software backs up all the servers and it does have SQL agent which...

I am not sure how to check this. The Infrastructure team built each server with the same 'Local System' account running all the services. I have been digging...

Good grief, you are only just up the road. I am in Manchester so I could guess who you work for! So which firm are you going to...

Boxing Day is the day after Christmas and it is a traditional day off. It is supposed to be when employers gave small presents (boxes) to their staff. ...

I hope you have a better hole to go to!!

Freezing. The snow fell on UK also!!

Thanks for the help.

I am pleased to report that all packages ran successfully this morning. I think there was a contradiction in privileges between the user who created the packages and the...

I think I am beginning to get somewhere now as I suspect that I know what happened.

I will report back in the morning

This gets weirdier and weirdier. The first and second job succeeded but the last one failed. I checked the command line and it did have the encryption password.

Anyway...

Headache

I have double checked that the decrypt and password are there.

I have enabled the jobs for the early hours of the morning. I will report back in the morning.

Thanks...

The consultant used 'EncryptSensitiveWithPassword'.

The things I do not understand is that it was working fine for months and then just stopped. I can only think that he...

Tried again as the file did not seem to have saved the settings. This time I got a different response. I say the same screen shot when trying...