Answered by:
sql server 2012 login transfer to 2012

Question
-
hi,
i have 2 mssql server one is std and another is ent edition. i created 3 database and transfer them from one sql server to another . it was successfully transfered.now i tried to transfer the login from old server to new one with their respective permission on each database. how can i perform this task. please tell me the simplest way. coz i am very new to sql server. don't know scripting.
plz help.
Friday, April 11, 2014 10:57 AM
Answers
-
- Edited by Olaf HelperMVP Wednesday, April 16, 2014 7:11 AM
- Marked as answer by vinit kishnatrey Wednesday, April 16, 2014 8:51 AM
Wednesday, April 16, 2014 7:11 AM -
hi
, thanks for the information sofia,
the link provided by you is applicable for 2005 sql . and i am working on server 2012.
http://support.microsoft.com/kb/246133/en-us
please help for server 2012
- Marked as answer by vinit kishnatrey Wednesday, April 16, 2014 8:53 AM
Wednesday, April 16, 2014 6:45 AM
All replies
-
i tried to transfer the login from old server to new one with their respective permission on each database.
Hello,
The permissions are stored within the database, so if you copy (backup/restore) the database all permissions exists as before / as in the source database.
To Transfer SQL Logins with the same Password see: How to transfer logins and passwords between instances of SQL Server
Olaf Helper
[ Blog] [ Xing] [ MVP]- Proposed as answer by Sofiya Li Monday, April 14, 2014 7:20 AM
Friday, April 11, 2014 11:03 AM -
Please take help of below link
http://support.microsoft.com/kb/918992/en-gb
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Proposed as answer by Sofiya Li Monday, April 14, 2014 7:20 AM
Friday, April 11, 2014 11:04 AM -
hi
, thanks for the information sofia,
the link provided by you is applicable for 2005 sql . and i am working on server 2012.
http://support.microsoft.com/kb/246133/en-us
please help for server 2012
- Marked as answer by vinit kishnatrey Wednesday, April 16, 2014 8:53 AM
Wednesday, April 16, 2014 6:45 AM -
- Edited by Olaf HelperMVP Wednesday, April 16, 2014 7:11 AM
- Marked as answer by vinit kishnatrey Wednesday, April 16, 2014 8:51 AM
Wednesday, April 16, 2014 7:11 AM -
hi after running script , i don know where it create the store procedures
Wednesday, April 16, 2014 8:04 AM -
thanks a lot.... done......it will be more easy if you can provide the screenshot or video....anyways thanks again
Cheers....
Wednesday, April 16, 2014 8:53 AM