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 22:05:33 +0200

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...
> 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: BULK INSERT from a mapped drive
    ... Tibor Karaszi, SQL Server MVP ... the mapped drive is visible & accessible by the Account. ... >> Tibor Karaszi, SQL Server MVP ... >>> MSSQLSERVER-service is also configured as a Domain-Account. ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing Start-up and Agent Accounts
    ... If SQL Server need access to network resources, ... for SQL Server agent. ... Tibor Karaszi, SQL Server MVP ... > Is it always better to replace Local System Account as the MSSQLSERVER startup account with an Administrator ...
    (microsoft.public.sqlserver.server)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)