Re: Bulk Insert

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/06/04 

Date: Tue, 06 Apr 2004 14:13:14 -0600

Check the account and permissions for the SQL Server
service. It needs to be a domain account with the
appropriate access. Sounds like you could be running the
service under LocalSystem which does not have access to
network resources.

-Sue

On Tue, 6 Apr 2004 12:23:32 -0700, "Eric"
<anonymous@discussions.microsoft.com> wrote:

>I cannot bulk insert a file from a network drive. Getting
>an error that access is denied. However, if I run the
>file name from the start menu it will open the file just
>fine or if I run the bulk insert from the local drive of
>the server it runs fine.
>
>The directory on the network is everyone full control.
>
>Any idea's?

Relevant Pages

  • RE: Minimum SSRS Service Account Permissions Required
    ... You can create a Domain Account, set it to run as server with no special ... And on the SQL server that has the Reporting Database installed ... I'm trying to find and understand the minimum set of permissions required by ... an SSRS domain service account to run SSRS on an application server and have ...
    (microsoft.public.sqlserver.security)
  • Link to Server via Windows Authentication
    ... what thier domain account has permissions to do. ... >>has Windows only authentication from another SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Setup Issue Reporting Services
    ... I'm having a small problem with the setup of SQL Server 2008. ... Accounts in the "Administrators" group can not get in. ... when a domain account is give "Content Manager" permissions they still can't ...
    (microsoft.public.sqlserver.setup)
  • Re: Linked Server Connection Problem
    ... Use SQL authentication to connect to the SQL server from the client, ... set the domain account used to start SQL Server to have permissions in the ... Establish a SPN for your domain account which will enable Kerberos ... Load the Active Directory Users and Computers MMC snap-in. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Services account question...
    ... I wish you'd say the reason of not using a domain account as a service account for the SQL Server. ... Backup operations are performed by SQL Server service, at this point I don't know what goes on under hood exactly but SQL Server service may be needed to communicate to the AD for validation of the database owner and as the SQL Server service is a local one, it can't achieve this task. ... > Source: Security Event ID: 537 ...
    (microsoft.public.sqlserver.security)