SQL Server Performance Forum – Threads Archive
moving db and login accountshello, 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 linkhttp://vyaskn.tripod.com/moving_sql_server.htm from Vyas and other corresponding links to accomplish the task. This link for migration of loginshttp://www.databasejournal.com/features/mssql/article.php/2228611 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=http://www.databasejournal.com/img/sp_help_revlogin.sql>http://www.databasejournal.com/img/sp_help_revlogin.sql</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 */