August 21, 2008 at 7:09 am
Hi Everyone,
I'm running into what I believe is a security issue sending files over to our storage management server using IBM's TSM. I've ran the command seperately in a command prompt and everything works fine with my own login, I though at first that the sql server agent login didn't have the correct permissions define, so I changed the service to use my own login (I know, not best practice, but I was just testing). basically I have a 2 step job schedule that uses a maintenance plan to backup all the databases locally to disk, (which works). The second step runs a cmdexec to send the file over to our tsm server. basically the command is: dsmc.exe incremental "d:\mssql\backups\s1161606\*" "-verbose"
The error message I'm getting is...
Executed as user: GTNA\sqlserveragent. The process could not be created for step 2 of job 0x1C1E344A9F3804429FE8ADD5F49D2DF8 (reason: Access is denied). The step failed.
Any ideas?
August 21, 2008 at 8:04 am
This same command works for you if you run it interactively?
Not sure what would be wrong here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply