moving db and login accounts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

moving db and login accounts

hello, i am moving a sql db from one server to another. how do i move the login accounts to the destination server? thanks
Far as I am aware of there isn#%92t an easy way of transferring login accounts between servers accurately.
Basically scripting up the account creations manually from the ‘donor#%92 server to the ‘recipient#%92 server. Is the login accounts are windows accounts or SQL accounts? Jozsef

Follow this link from Vyas and other corresponding links to accomplish the task. This link for migration of logins will help. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I especially like the SID copy in<a target="_blank" href=></a><br />Thanks for the link Satya <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> <br /><br />Jozsef<br />
The following steps will work: 1) Move database by using ur prefered way (attach/dettach, backup/restore)
2) Execute sp_help_revlogin from the source database server. Save the generated script.
3) Execute the generated script in the targer server.
4) If requires synchornise the database users with sql logins (by using sp_change_users_login). You can also use DTS Transfer logins task.
/* SKChandra */