Thursday, February 9, 2012

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.
Thanks
SharonDid 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.|||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.

No comments:

Post a Comment