Re: BULK INSERT from a mapped drive

From: Marc (newsgroups_at_ris-nospam-web.net)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 20:31:58 +0200

Tibor,

Yes, the mapped drive is visible & accessible by the Account.

Marc

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> schrieb
im Newsbeitrag news:O0QxpUhLEHA.1388@TK2MSFTNGP09.phx.gbl...
> Fist thing to try would be to log in as the SQL Server service account as
see if the mapping exists for that
> account.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Marc" <newsgroups@ris-nospam-web.net> wrote in message
news:409143a0$0$713$5402220f@news.sunrise.ch...
> > Hi
> >
> > I'm trying to BULK INSERT some data from a simple text file, residing on
a
> > mapped drive (F:\)
> > Well, I know, it's better to use UNC-Paths, but it was "programmed" in
that
> > manner some years ago. (Some dozens of stored procs which I don't want
to
> > change)
> >
> > This problem persists since we upgraded from NT/2000 to Server2003
(still
> > using SQL 2000):
> > while trying to bulk insert, I get an error, that the file can't be
> > found/accessed. (Path is correct)
> >
> > MSDTC is configured running as a Domain-Account, and accessing the
network
> > (COM-Configuration)
> > MSSQLSERVER-service is also configured as a Domain-Account.
> > Could this be a setting in Server2003 which I didn't found yet ???
> >
> > Any help would be appreciated
> > Many thanks & regards,
> > Marc
> >
> >
>
>

Relevant Pages

  • Re: EXEC sp w/ BULK INSERT - problem w/ security
    ... If you have a security problem with the BULK Insert command, ... this newsgroup is about ADP and SQL-Server and has nothing to do with ... as D:\) are strongly associated with the login account and the fact that D:\ ... When run from SQL Server Management Studio, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: EXEC sp w/ BULK INSERT - problem w/ security
    ... Select the specific user - in my case a SQL Server login ... That particular login now may make use of BULK INSERT. ... under a system account that it doesn't have cross-platform access. ... this newsgroup is about ADP and SQL-Server and has nothing to do with ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Bulk Insert permission
    ... I had misread which account that Bulk Insert runs under. ... If a SQL Server user is logged in using Windows Authentication, ... or configure Windows to enable security account delegation. ...
    (microsoft.public.sqlserver.programming)
  • Re: Bulk Insert permission
    ... If a SQL Server user is logged in using Windows Authentication, the user can read only the files accessible to the user account, independent of the security profile of the SQL Server process. ... When executing the BULK INSERT statement by using sqlcmd or osql, from one computer, inserting data into SQL Server on a second computer, and specifying a data_file on third computer by using a UNC path, you may receive a 4861 error. ... To resolve this error, use SQL Server Authentication and specify a SQL Server login that uses the security profile of the SQL Server process account, or configure Windows to enable security account delegation. ...
    (microsoft.public.sqlserver.programming)
  • Re: BULK Insert Problem
    ... Vyas, MVP (SQL Server) ... I Log on to my system using the Local System Administrator Account. ... And If I Try to Bulk Insert any thing from my ...
    (microsoft.public.sqlserver.programming)