Re: BULK INSERT from a mapped drive

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 20:09:47 +0200

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: BULK INSERT from a mapped drive
    ... Fist thing to try would be to log in as the SQL Server service account as see if the mapping exists for that ... Tibor Karaszi, SQL Server MVP ... > MSDTC is configured running as a Domain-Account, ... > MSSQLSERVER-service is also configured as a Domain-Account. ...
    (microsoft.public.sqlserver.programming)
  • Re: error in executing exec xp_cmdshell
    ... > admin group. ... Did you assign the SQL Server service account the advanced user rights ... The rights are needed so that SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: OPENROWSET/OPENDATASOURCE, Security, UNC - Help Please
    ... The JET provider is being instantiated outside the SQL Server process. ... When the caller is an integrated security login then SQL ... login of the caller rather than the SQL Server service account. ...
    (microsoft.public.sqlserver.security)
  • Re: OPENROWSET/OPENDATASOURCE, Security, UNC - Help Please
    ... The JET provider is being instantiated outside the SQL Server process. ... When the caller is an integrated security login then SQL ... login of the caller rather than the SQL Server service account. ...
    (microsoft.public.sqlserver.security)
  • Re: AWE Memory
    ... Check Lock pages in memory list for that account or whatever SQL Server service account it. ... it's recommended using a domain account as SQL Server service if your SQL Server is in a domain environment. ...
    (microsoft.public.sqlserver.security)