BULK INSERT from a mapped drive

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,
MarcFist thing to try would be to log in as the SQL Server service account as se
e 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.su
nrise.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 tha
t
> 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
>|||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...
a[vbcol=seagreen]
that[vbcol=seagreen]
to[vbcol=seagreen]
(still[vbcol=seagreen]
network[vbcol=seagreen]
>|||Hmm, then I can only assume that there's some new stuff in W2K3 that I haven
't heard about before. Perhaps
post this to a Windows forum as a general question ("service accessing share
through mapped drive")?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Marc" <newsgroups@.ris-nospam-web.net> wrote in message news:40914a26$0$704$5402220f@.news.su
nrise.ch...
> 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...
> see if the mapping exists for that
> news:409143a0$0$713$5402220f@.news.sunrise.ch...
> a
> that
> to
> (still
> network
>|||Tibor,
Thank's for your help...
Marc
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:uoy$WViLEHA.1388@.TK2MSFTNGP09.phx.gbl...
> Hmm, then I can only assume that there's some new stuff in W2K3 that I
haven't heard about before. Perhaps
> post this to a Windows forum as a general question ("service accessing
share through mapped drive")?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Marc" <newsgroups@.ris-nospam-web.net> wrote in message
news:40914a26$0$704$5402220f@.news.sunrise.ch...
schrieb[vbcol=seagreen]
as[vbcol=seagreen]
residing on[vbcol=seagreen]
in[vbcol=seagreen]
want[vbcol=seagreen]
>