Copy database to different domain

• Ed-207611

  Valued Member

  Points: 57

  More actions

  April 13, 2005 at 7:35 am

  #102480

  Hi,

  I would like to copy a sql 2000 database to a sql 2000 server in a different domain. With DTS it is possible to export objects and with the transfer login task you can copy the logins including the passwords. But because I have to copy to a different domain, I have a problem with the SID. How can I solve this problem?

  Is DTS the best way to copy a database to a different domain

  Regards,

  Ed

• Martin Mojzisek

  SSCrazy

  Points: 2207

  More actions

  April 13, 2005 at 10:07 am

  #552473

  see this article:

  http://support.microsoft.com/kb/240872/EN-US/

  I've never had to do that so I can offer no personal experience