Login Name/User Name mismatch

• Gary Cobden

  Ten Centuries

  Points: 1269

  More actions

  June 27, 2006 at 4:01 pm

  #67499

  Hi

  I have recently restored a production database on to a new Disaster recovery server (SQL 2000) and am experiencing a problem with Login Name/User name mismatch

  On our production box we have the following

  User name                Login Name

  ARAdmin                   ARAdmin

  dbo

  On our Disaster Recovery Box we have

  User name                Login Name

  ARAdmin                  

  dbo                         ARAdmin

  Can anybody tell me how I can get the D/R box User/Logins to match the Production box.

  Thanks

  Gary

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  June 27, 2006 at 4:10 pm

  #646243

  Looks you have to fix both.

  First, you can run sp_change_user_login to fix AR admin, see the link

  http://msdn2.microsoft.com/en-us/library/ms174378.aspx

  Then fix DBO on both servers by linking DBO to SA or other login by

  sp_changedbowner, see the link

  http://msdn2.microsoft.com/en-us/library/ms178630.aspx

   

   

   

  Regards,Yelena Varsha