Results 1 to 2 of 2

Thread: data transfer between domains

  1. #1
    Ryan Guest

    data transfer between domains


    Hello,
    I have a problem scheduling an Object Transfer task on a server that is in a different domain than the server it is getting the data from. I can set up the Object Transfer through the Tools/DatabaseObject Transfer... option and run it manually (works great), but if I schedule it to run, it stops after about 30 seconds and gives an error message "Process Exit Code 1. Cannot connect to source server." Any ideas would be much appreciated. Thank you
    Ryan

  2. #2
    Dale Shaw Guest

    data transfer between domains (reply)

    Hi

    Create a username and password in the 'source' domain as that used by the SQL Agent service on your server.


    Dale


Posting Permissions

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