Access the filesystem with SQL server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Brouwers - 24 Mar 2006 16:24 GMT

Hi,
We've got this strange situation. I want to perform a bulk insert in
SQLserver 2005 from a file on the file system. This works OK when I use a
SQLuser. When I do the same logged in with windows account (with
administrator privileges) I get an error. I thought that when I use a
windows account, this account is used to access the file system. When you
use a SQL account then the user of the sqlserver service is used to access
the filesystem. Am I wrong or how does this work ?

TIA

Reply to this Message

Rob Walters [MSFT] - 24 Mar 2006 19:25 GMT

Yes, the windows account will need access to the file on the file system as
well as be a user with enough privledges on the database to perform the
insert. Are you using BCP or are you using SSIS to do the transfer?

Signature

Rob Walters
Program Manager - SQL Server

> Hi,
> We've got this strange situation. I want to perform a bulk insert in
[quoted text clipped - 6 lines]
>
> TIA

Reply to this Message

Mark Brouwers - 27 Mar 2006 07:22 GMT

Thanks for the reply,
I just use a query window within the management studio. I run the sql
statement as a SQLuser and it works. I change the connection properties to
my windows account (with administrator privileges) and is stops working.

Mark

> Yes, the windows account will need access to the file on the file system
> as
[quoted text clipped - 12 lines]
>>
>> TIA

Reply to this Message