Re: Bulk Insert or even the cmdexec and xp_cmdshell is access denied?
From: aaa (renlaps@philwebinc.com)
Date: 09/11/02
- Next message: Wendy: "dbo access restrictions"
- Previous message: Rulle: "Firehose mode?"
- In reply to: Satya: "Bulk Insert or even the cmdexec and xp_cmdshell is access denied?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "aaa" <renlaps@philwebinc.com> Date: Wed, 11 Sep 2002 18:23:06 +0800
Sorry for the delay, I'm just back in the office,
It is possible the tight security or perhaps a very good firewall is causing
this restriction or maybe perhaps sql2k or windows 2k authentication
problem?.
Anyone have an idea or perhaps have the same scenario with me can advice me
with this kind of problem!
Thanks and regards,
"Satya" <satyaskj@yahoo.co.uk> wrote in message
news:f17101c258ce$d82f9720$3bef2ecf@TKMSFTNGXA10...
> Check the registry settings for the permissions to the SQL
> Service account you use to connect with REGEDT32 utility
> from command prompt.
> >-----Original Message-----
> >Why I'm denied in running the bulk insert command with
> the following
> >scenario?
> >
> >1. the sql server having domain account in our network is
> also having an
> >administrator rights locally.
> >2. the sql server is also having full rights to the
> workstation where I want
> >access the text file data.
> >3. the sql login also is an system administrator in sql.
> >
> >But why, I'm denied accessing the folders/files in the
> other workstation,
> >when I'm executing the command bulk insert or even the
> cmdexec in jobs or
> >xp_cmdshell in query analyzer.
> >
> >What I really want is to insert/import the text located
> on the other
> >workstation everyday, I'm thinking of using the jobs in
> sql, but so far,
> >found no good!
> >
> >Can someone help me regarding this?
> >
> >Thanks You in Advance!
> >Renato B. Lapera
> >
> >
> >.
> >
- Next message: Wendy: "dbo access restrictions"
- Previous message: Rulle: "Firehose mode?"
- In reply to: Satya: "Bulk Insert or even the cmdexec and xp_cmdshell is access denied?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
