Post reply

Copy files accross the network.

  • October 21, 2005 at 2:04 pm

    #110290

    Hi All,

    I tried this from sql:

    USE master

    EXEC xp_cmdshell 'copy c:\ftp_cmd_dmi.txt  \\192.266.251.10\c$\'

    It always returned message: 'Network path  was not found'.

    My source file is in sqlserver, and my destination file is on the web server. Is there any trick? I also tried xcopy command, but I got the same error message.

    Please help.

    Thanks,

    Minh Vu

     

     

  • October 21, 2005 at 2:18 pm

    #599307

    Does the SQL Server service account have rights on the remote server ?

    Also, since you are using the adminstrative share (c$), the account will need be a member of the Windows local admin group on the remote server.

    SQL = Scarcely Qualifies as a Language

  • October 21, 2005 at 2:20 pm

    #599312

    yes, it does have.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply