bcp queryout

I have a process that does a BCP "queryout" using xp_cmdshell to a Network
share. The process is being invoked by a non-sysadmin account. I receive the
error Cannot open BCP file.
Sql7 on a Windows N/T box.
How do you setup permissions to make happen?
Thanks.
Hi Andy
If you are running SQL Server Service Account as local system then you will
not have access to the network share, change this to a domain account that
has access and you should be ok.
John
"Andy" wrote:

> I have a process that does a BCP "queryout" using xp_cmdshell to a Network
> share. The process is being invoked by a non-sysadmin account. I receive the
> error Cannot open BCP file.
> Sql7 on a Windows N/T box.
> How do you setup permissions to make happen?
>
> Thanks.
>
>
>