Re: BULK Insert Problem
From: Prabhat (not_a_mail_at_hotmail.com)
Date: 05/03/04
- Next message: Konstantinos Michas: "ADDING A PRIMARY KEY"
- Previous message: Radovan Dobriæ: "Re: Deleting empty spaces in a string"
- In reply to: Narayana Vyas Kondreddi: "Re: BULK Insert Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 3 May 2004 14:30:24 +0530
Hi Vyas,
Thanks. Your Solution worked WELL.
Thanks
Prabhat
"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:uNrsUlOMEHA.3052@TK2MSFTNGP12.phx.gbl...
> Look up MSSQLServer service in the Services applet (Control Panel ->
> Administrative Tools). Can also be verified from 'Computer Management'
> window in administrative tools.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
>
>
> "Prabhat" <not_a_mail@hotmail.com> wrote in message
> news:uVI5MhOMEHA.2276@TK2MSFTNGP09.phx.gbl...
> Thanks for your reply.
>
> By How do I check that?
>
> I Log on to my system using the Local System Administrator Account. So How
> do I see that The SQL Server Service is starting using the Local Account
and
> How Do I change that to Domain Account?
>
> Thanks
> Prabhat
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:uY5JIcOMEHA.1156@TK2MSFTNGP09.phx.gbl...
> > Is your SQL Server service account a local account? If so, convert that
to
> a
> > domain account and make sure that domain account has access to the file
> you
> > are trying to bulk load.
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> >
> >
> > "Prabhat" <not_a_mail@hotmail.com> wrote in message
> > news:emWNA8NMEHA.644@tk2msftngp13.phx.gbl...
> > Hi All,
> >
> > I work in a Network Environment. My System Number is "system1" where the
> SQL
> > Server DB is Installed. And If I Try to Bulk Insert any thing from my
> system
> > Then it works fine.
> >
> > But If I Try to do Any BULK INsert from "system2" then I Get the below
> > ERROR!!!!
> >
> > Server: Msg 4861, Level 16, State 1, Line 1
> > Could not bulk insert because file '\\radsoftech-115\MSF\Import\Jules
> > Kuperberg NY List 1 12-18-03.csv' could not be opened. Operating system
> > error code 5(Access is denied.).
> >
> > My SQL Statement to FROM_ACQ table is Like:
> >
> > BULK INSERT FROM_ACQ
> > FROM '\\usert2\Import\NY_List.csv'
> > WITH (FIRSTROW = 2, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
> >
> >
> > Even I CAN Open that file of system2 from my system using "Start - RUN".
> My
> > SQL Server Startup is Done in ADMINISTRATOR Account, and Same with
System2
> > also. Both the systems are having same possword for the user
> Administraotr.
> > Owner of the DB is User1\Administrator.
> >
> > So where is the problem? Any Help.
> >
> > Thanks in Advance.
> > Prabhat
> >
> >
> >
> >
> >
>
>
>
>
- Next message: Konstantinos Michas: "ADDING A PRIMARY KEY"
- Previous message: Radovan Dobriæ: "Re: Deleting empty spaces in a string"
- In reply to: Narayana Vyas Kondreddi: "Re: BULK Insert Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
