Post reply

Fixing of logins across domains

  • June 1, 2010 at 11:30 pm

    #221691

    Hi,

    If am trying to transfer sql logins or across domains am restoring the backups. How would i map the SID's?

    How to resolve the problem?

    Can anybody explain how sql server internal does the fixing/mapping of Logins??

  • June 2, 2010 at 5:07 am

    #1175203

    [font="Verdana"]****Please change name of the database before executing the script*****

    Use 'Database Name'

    go

    SELECT

    'EXEC sp_change_users_login ''Update_One'', ''' + su.name + ''', ''' + su.name + ''''

    FROM

    sysusers su

    LEFT JOIN master.dbo.syslogins sl ON su.sid = sl.sid

    WHERE

    uid > 3

    -- exclude public, dbo, guest, INFORMATION_SCHEMA

    AND uid <> gid-- exclude groups

    AND uid < 16384-- exclude database roles

    AND sl.sid IS NULL-- user not linked to a login

    ORDER BY su.name

    Execute Output of this script in another or same window and it should do the job for you.

    Njoi SQL'ing[/font]

    ~RD

  • June 2, 2010 at 11:22 am

    #1175458

    This has to be executed on the source sql server and take the output and execcute it on the target sql server. Right??

    Correct me if am wrong!!!

    Thanks.

  • June 9, 2010 at 5:44 am

    #1177918

    No, that happens on the destination server later. First read this: http://support.microsoft.com/kb/918992 about how to script out the logins and passwords on the source server and run the scripts on the destination. Once you've got the logins transferred, check out BOL for sp_change_users_login.

  • June 9, 2010 at 10:44 am

    #1178109

    Thanks a lot!

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

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