locked
sql server 2012 login transfer to 2012 RRS feed

  • 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

  • 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]


    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

    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

    Wednesday, April 16, 2014 6:45 AM
  • 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]


    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