Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2007-02-19 : 15:59:56
|
| Hi Guys,I am running my SQL Server 2000 under "This system account" I am logged in locally as Administrator.My Network depart has a DMZ networ, which is currently being used for FTP file transferes. to access that server we have to enter User name and password of that DMZ server.Here is the problem.When I used the command like thatINSERT dlg_FTP_filedetails(alternatename,size,creation_date,creation_time,last_written_date,last_written_time,last_accessed_date,last_accessed_time,attributes) EXEC master.dbo.xp_getfiledetails '\\nplftp01\DialogFTPRoot\AAR\TestFromDialog\ABC.TXT'Where NPLFTO01 is DMZ FTP folder.It straight away says Access denied.Any idea how to overcome this situation?Thanks is advanceSKR |
|
|
|
|
|
SQL server and Local System account & DMZ network