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: 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)
  • [TOOL] Resources for Combating the Slammer Worm
    ... installations of Microsoft® SQL Server™ and the Microsoft SQL Server ... SQL Server 2000 SQL Scan Tool ... runs on computers running Windows 2000 or higher and can identify ... Check runs on computers running Windows 98, Windows ME, Windows NT 4.0, ...
    (Securiteam)
  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... connection but unless you're good at setting up groups/schema/logins/users, ... Windows auth is slower as the domain must ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connect problem MSDE ADO ASP
    ... problems on setting the IIS User password. ... result - and both can access the MSDE SQL via the webinterface (I am aware I ... > your connection string, and put in a valid SQL USER ACCOUNT, not a Windows ...
    (microsoft.public.sqlserver.programming)