Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 sp_change_users_login

Author  Topic 

magmo
Aged Yak Warrior

558 Posts

Posted - 2010-06-11 : 09:55:09
Hi

I have restored a database on a different machine, and now I have to solve the users issue in the database. There are 4 orpahaned users. I have checked this like this..

EXEC sp_change_users_login 'Report'

Is it posssible to restore the orpaned users and their passwords to the database without knowing the original password. Or do I have to create new passwords?
   

- Advertisement -