December 13, 2007 at 7:48 am
Hi All,
Am trying to create a job in management studio 2005, that uses an sql
server agent proxy, but when I try to open the Active X proxy (a vbs script)
on my my c:\drive, it gives me error message: Access to the path 'C:\Program
files\Microsoft Learning\2780\Mod7\Practices\CreateOrder.vbs' is denied.
(mscorlib). I tried to shared the drive in the folder security, but no joy.
fosco
December 13, 2007 at 7:51 am
It's a security issue. Is this a job that's running on your workstation? Or is a remote server? Don't forget that pathing on the server is absolute to the server, not the client tool.
c: in a job is c: on a server, not your workstation. Management Studio gives you an interface into the server, nothing is running related to jobs in the client.
December 13, 2007 at 8:28 am
Am logged into sql server via my domain account, I have a domain, the C:\drive is for my workstation as you suggested, am creating the jobs using a window user account on my domain, but it seems the job is not able to access the drive to open the vbs script, how can I get around it, is there anyway I could save the script in sql server?
December 13, 2007 at 11:44 am
Hi All,
Silly me, the script was supposed to save to a path pointing to D:\ and when I
check inside the script I discovered this, so the job was able to execute as
instructed, changed it to C:\ drive and it worked, thanks so much.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply