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.

Answer 1

 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]

Answer 2

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

Answer 3

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

Answer 4

the link provided by you is applicable for 2005 sql . and i am working on server 2012.

That doesn't matter, the script works in all Version from 7.0, 2000 up to 2014.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 5

hi  after running script , i don know where it create the store procedures

Answer 6

thanks a lot.... done......it will be more easy if you can provide the screenshot or video....anyways thanks again

Cheers....