June 5, 2006 at 3:55 am
Apologies if this is covered elsewhere:
We have recently upgraded to 2005 and have always backed up to a different server using a maintenance plan using 200 without problem
However 2005 is immediately failing when I try to set up the job to do so now - it will backup locally fine. Which would make it appear to be a security issue, but if I pull out the T-SQL from the maintenance plan and run a backup job from a Query tab it runs fine...
If its relevant I installed SSIS after the main install (service runs as a Domain Admin account)
Any idea's?
June 5, 2006 at 8:51 am
I would check the security log on the server where the backups are supposed to go. It will show who is trying to access your share. You run your Management Studio in the security context of your Windows user. Check what is the security context of the process that executes your backup.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply