SQL Server Performance

SQL Login Transfer with password

Discussion in 'SQL Server 2005 General DBA Questions' started by danny123, Aug 13, 2010.

  1. danny123 New Member

    Hi there,
    We are in process of migrating our servers to a new location. For disaster recovery plan, I am working on the script
    all the Logins (with same password) on the server and their database mappings with role.
    Now i found the script on Microsoft site using sp_help_revlogin stored procedure. But that script just create Logins with
    same password but does not map the logins to databases with corresponding roles.
    So i created the script using Idera SQL Permissoins Tool, which scripts all the database users and their permissions.
    This way i have to use the script from 2 sources, and use them. Is there any script available which i can use and that serve
    all the purposes?
    Thanks!
  2. rohit2900 Member

    while generating the script you have once option called script database users and object level permissions. try this.
    Rohit
  3. dineshasanka Moderator

    http://weblogs.sqlteam.com/billg/archive/2010/07/08/Scripting-out-SQL-Server-Logins.aspx
  4. ashish287 New Member

    have you tried sp_change_users_login
    'report'
    to give you the report of all logins which are not matching in new server.
  5. satya Moderator

    Follow what Rohit mentioned which can get the information.

Share This Page