Post reply

sp_help_revlogin

  • June 7, 2011 at 3:17 am

    #145614

    Hi Team,

    I am trying to migrate logins from one server to another.

    So i generated the login script using sp_help_revlogin.

    I executed the output in the destination server and i got all the logins in the destination server.

    But the problem is i am not getting the proper @access rights" as of source server in the destination server.Logins are getting connected.But access is missing.

    Any help will be appreciated

  • June 7, 2011 at 4:42 am

    #1334881

    Try applying login fix for some of the logins and check.

  • June 7, 2011 at 4:44 am

    #1334882

    EXEC sp_change_users_login 'Auto_Fix', 'User'

  • June 7, 2011 at 4:54 am

    #1334887

    haichells (6/7/2011)

    EXEC sp_change_users_login 'Auto_Fix', 'User'

    above query is to vheck the unmapped users right?

    when the logins whose SID is not mapped

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply