Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Question Unanswered: Anyone use Copy Database Wizard across domains?

    Has anyone been able to successfully use the database copy wizard to copy databases between domains?

    I've got a SQL 7.0 database on domain A. I need to move it to domain B and upgrade it to SQL 2000.


  2. #2
    Join Date
    May 2003
    Parsippany NJ
    Did you try to add the remote server from client network utility by IP Address and correct Port Number. Since it's in different domain, you may require SQL authentication(sysadmin userid/pwd). Make sure you do enought testing before proceeding to production.

  3. #3
    Join Date
    May 2004

    Yes but...

    The problem really has to do with the requirement that the user have local admin rights.

    I can get the copy wizard to begin using sql authentication, but I always get an error trying to create the OMWWIZE share.

    I was hoping for a way around this.

Posting Permissions

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