Access the filesystem with SQL server 2005

From: "Mark Brouwers" <NoSpam@xxxxxxxxx>
Date: Fri, 24 Mar 2006 16:24:23 +0100

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

.

Prev by Date: Moving an MSDE app to SQL Express
Next by Date: Configuring and securing sql server 2005 Express
Previous by thread: Moving an MSDE app to SQL Express
Next by thread: Re: Access the filesystem with SQL server 2005
Index(es):
- Date
- Thread

Relevant Pages

Storing Images?
... File System ... Database (SqlServer) (Seems to be easier, but has a performance hit) ...
(microsoft.public.dotnet.framework.aspnet)
Re: Sharepoint 2007: retrieving sharepoint files to a file system
... retireve Sharepoint date to a file system. ... Supposing that the data ... SQLServer ... 2005 backend as BLOBs: what means should I investigate to get the ...
(microsoft.public.sharepoint.portalserver)