changing the login name

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  March 9, 2005 at 8:58 am

  #163502

  hai,

  I have a db with db user "xsadmin" with login name "log_xsadmin"  and

  Corresponding to "dbo" the login was "sa"

  i have restored this db to another machine and after restoration the associaiton changed like this

  dbo is associataed with log_xsadmin, and i am not able to make dbo with sa...

  how can i do this. i have tried

  sp_change_users_login 'update one' ,'dbo','sa'

  and it is giving error....

  pls help, how can i change login for 'dbo' to 'sa'

   

  
  subban

• Martin Mojzisek

  SSCrazy

  Points: 2207

  More actions

  March 9, 2005 at 9:32 am

  #546171

  Does log_xsadmin login exists on the new server? if not create it and run

  sp_change_users_login 'update_one' ,'xsadmin','log_xsadmin'

  these steps should synchronize syslogins and sysusers tables on the new server.

  I'm not sure what things with sa will be now, but if sa is still not mapped to dbo user, run

  use your_db_name

  sp_changedbowner 'sa'

   

   

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  March 10, 2005 at 12:49 am

  #546299

  thanks i got the idea

  
  subban