Re: Access the filesystem with SQL server 2005

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

"Rob Walters [MSFT]" <RobWaltersMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4BBBCCE0-EFBD-4FD4-B046-B9C5371DA9E8@xxxxxxxxxxxxxxxx
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?
--
Rob Walters
Program Manager - SQL Server



"Mark Brouwers" wrote:

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





.

Relevant Pages

  • RE: Keeping User From Deleting Table Records
    ... authentication and authenticate with Windows. ... Windows or is this SQL-assigned read permission done through SQL Server? ... I have tested with a test Windows account (network OS is Win2003 ...
    (microsoft.public.sqlserver.security)
  • Re: Trying to get a VB.net sample working with SQL Server.
    ... SQL accounts and Windows ... >> ASPNET is a windows account.. ... >> the current user (which going to be the ASPNET user, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: problem connecting server from client through enterprose manager
    ... * If you are logging in with SQL authentication, ... configured to accept both SQL and Windows authentication. ... with exists in SQL Server (a Windows account could exist through group ... Does the connection fail from Query Analyzer on the client, ...
    (microsoft.public.sqlserver.clients)
  • Windows Impersonation authentication to SQL Server?
    ... Impersonation will each Windows Domain user accounts need to be granted ... all be tracked and displayed in SQL Profiler? ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication to SQL Server?
    ... oranges in trying to convert an asp.net app which uses forms authentication ... mode throughout the app with one SQL login account into SQL Server versus ... converting the asp.net app into a full individual Windows authentication ... Ultimate goal would be to see the individual windows ...
    (microsoft.public.dotnet.framework.aspnet.security)