Drop User from a restore

• gedeon

  SSC Veteran

  Points: 262

  More actions

  December 24, 2002 at 2:26 am

  #105392

  Hi everybody and merry Christmas,

  I have a small issue with a restore. I have made a backup on server A and I need to restore it on server B.

  For the restore there is no problem but I have used in some database local NT Groups !

  ex: A\SQLDEVELOPERS and B\SQLDEVELOPERS.

  When I try to give access on the restore DB on server B to the B\SQLDEVELOPERS group , it is not possible, user already exist.

  When I try to drop the group SQLDEVELOPERS from the server B, user does not exist !

  Is someone as an Idea ?

  
  Best regards,
  
  Michael.

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  December 24, 2002 at 3:10 am

  #445089

  Hi, try this article: -

  http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

  Regards,

  Andy Jones

  .

• Antares686

  SSC Guru

  Points: 125444

  More actions

  December 24, 2002 at 4:09 am

  #445090

  Try this or fix as needed as I am guessing to you needs.

  Use YourDBNameHere

  GO

  EXEC sp_change_users_login 'Update_One', 'SQLDEVELOPERS', 'SQLDEVELOPERS'

  GO

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  December 24, 2002 at 8:02 am

  #445094

  This article might give some ideas:

  http://www.sqlservercentral.com/columnists/glarsen/orphan_user.asp

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• gedeon

  SSC Veteran

  Points: 262

  More actions

  December 31, 2002 at 12:58 am

  #445310

  Thanks to all for your answers.

  
  Best regards,
  
  Michael.