restore a database to a new SQL 2005 SERVER

• koen_huys

  Old Hand

  Points: 337

  More actions

  December 9, 2014 at 12:44 pm

  #145443

  a good evening,

  I want to restore a database (sql 2005 ) to a completely new sql2005 server

  When I do this then I see the database

  but with the user I see the name but the login is empty and grey so I can't change it

  can somebody tell me how to resolve this problem

• koen_huys

  Old Hand

  Points: 337

  More actions

  December 11, 2014 at 1:21 am

  #1763968

  resolved with the below query

  USE [database];

  Go

  sp_change_users_login @Action= 'update_one', @UserNamePattern=,

  @LoginName=[loginname];

  GO