Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Question Unanswered: problem accessing anouther server from SP

    I have a stored procedure that is running on SERVER1

    it uses xp_cmdshell to access a folder on anouther server SERVER2
    read any and all text files in the folder and if there are files import them
    into table.

    everything is working when files are on local drive, when I try using the folder on the SERVER2 I get access denied msg.

    I have tried everything :
    Seting proxy,
    changing the login user for services
    maping the drive

    NOTHING works

    the servers are as folow :

    SERVER1 : is win 2003 with no domain (workgroup)
    SERVER2 : is Win 2000 with no domain (workgroup)

    I have a shared folder on SERVER2 with alow permision for everyone set
    I can access this folder through everything except SQL SP.

    Any one have any ideas???

  2. #2
    Join Date
    Dec 2004
    CA, USA
    Please post the SP. I'd like to take a look.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts