permission issues when detach/attach to new server

• Pascual de la Cruz

  SSC Veteran

  Points: 227

  More actions

  February 15, 2005 at 1:05 am

  #162645

  Hello,

  Does somebody knows a complete solution for resolving the following issues

  when moving or copying a database to another sql server?

  - when attaching the moved database, i have orphan users. So i use the

  sp_help_revlogin to re-create those users. This works ok.

  - when attaching a database which has roles and permissions defined, the

  only thing that gets fixed are the logins.

  I hope somebody has faced this problem before and can give me a solution.

• Yoav S.

  SSC Eights!

  Points: 924

  More actions

  February 15, 2005 at 5:23 am

  #542245

  Hey,

  Try this link http://support.microsoft.com/default.aspx?kbid=246133

  And this http://support.microsoft.com/default.aspx?scid=kb;en-us;240872

   

  yoav.

• Pascual de la Cruz

  SSC Veteran

  Points: 227

  More actions

  February 15, 2005 at 5:42 am

  #542247

  Hi yoav,

  I've already tried those articles, but no luck. It works if you have no roles in the database.

  Do you know an alternative solution?