Showing posts with label agent. Show all posts
Showing posts with label agent. Show all posts

Saturday, February 11, 2012

Access denied to vbs file

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.
foscoHi All,
Silly me, the script was supposed to save to a path pointing to D:\ and I
check inside the script to discover this, so the job was able to execute as
instructed, changed it to C:\ drive and it worked, thanks so much.
Fosco
"fosco" <folabii@.hotmail.com> wrote in message
news:edmrXaZPIHA.1756@.TK2MSFTNGP06.phx.gbl...
> 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
>

Access denied to vbs file

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
Hi All,
Silly me, the script was supposed to save to a path pointing to D:\ and I
check inside the script to discover this, so the job was able to execute as
instructed, changed it to C:\ drive and it worked, thanks so much.
Fosco
"fosco" <folabii@.hotmail.com> wrote in message
news:edmrXaZPIHA.1756@.TK2MSFTNGP06.phx.gbl...
> 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
>

Thursday, February 9, 2012

Access Denied on BCP file for push

I setup a snapshot with 2 subscribers I started one push agent - let it
finish - stopped the agent and started the second push agent. The following
error is returned almost immediately...
..........bcp could not be opened. Operating System error code 5(Access
Denied) .........
Any ideas?
You're permissions on the Subscriber is what it sounds like. RClick the
Publisher/ Props/ Replication/ Configure/ Subscribers/ "..." button next to
the Subscriber/ see who you are connecting to the Subscriber as.
"frankm" <frankm@.nospam.postalias> wrote in message
news:u6yL7rKqFHA.3720@.TK2MSFTNGP14.phx.gbl...
>I setup a snapshot with 2 subscribers I started one push agent - let it
> finish - stopped the agent and started the second push agent. The
> following
> error is returned almost immediately...
> .........bcp could not be opened. Operating System error code 5(Access
> Denied) .........
> Any ideas?
>