Re: BULK Insert Problem

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 05/03/04

  • Next message: Radovan Dobriæ: "Re: Deleting empty spaces in a string" 
    Date: Mon, 3 May 2004 09:32:24 +0530

    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: Radovan Dobriæ: "Re: Deleting empty spaces in a string"

    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: SQL Agent cannot run DTS packages that contain Analysis Services tasks
      ... >The source of the problem seems to be the Windows account the agent runs as. ... >into an administrator on the server where MS Analysis Services is installed. ... Darren Green (SQL Server MVP) ...
      (microsoft.public.sqlserver.dts)
    • 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: MSSQL$SBSMONITORING Login to Disabled Account?
      ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
      (microsoft.public.windows.server.sbs)
    • Re: Microsoft Search service cannot be administered under the present user error SP3
      ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
      (microsoft.public.sqlserver.server)
    Loading