File Permissions for BCP job

From: DeeJay Puar (deejaypuar_at_yahoo.com)
Date: 05/15/03 

Date: Thu, 15 May 2003 12:43:11 -0700

Dave,

You have to make sure that the SQLServerAgent Service is
running under a domain account. Schedule your job (or
change the owner to this account) to run as the same user.

On the other file server, grant this service account
permissions to the file/directory properly.

This should do the job.

DeeJay
>-----Original Message-----
>How can I grant Win2k NTFS file permissions on a file
>server to BCP running as a SQL job on another SQL server
>computer? Granting file perms to the computer doesn't
>work.
>
>Thanks,
>Dave
>.
>

Relevant Pages

  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... Client computer must use STRICTLY the INTERNAL DNS server which can ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Re: Same question, still no answer!!!
    ... Sounds then like we are all paying for a feature set only large companies ... The "proxy server" pc is actually an older box stuffed ... Expectation #1) keep the ethernet more or less as is. ... The kids account would be ...
    (microsoft.public.windowsxp.basics)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Sending email to mydomain.com
    ... server will appear as undeliverable. ... This happens because you are using the POP3 connector... ... an NDR when an account doesn't exist). ... >different from the user account names for the exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: Basic Authentication + IIS 5 + Windows 2000 + Frontpage 2002 = failure?
    ... Everytime I attempt to login under Basic Authentication, ... IUSR_blah account. ... the anonymous user impersonated by the IIS Server is the ... > Event Viewer Security log. ...
    (microsoft.public.inetserver.iis.security)