Transfer logins 2008->2008

  • Hi all.

    Explain me plese how I should transfer logins from one sql server 2008 to another.

    I tried to do that by means Integration service. Logins transferred successful but did not work.

    I tried to transfer with SIDs and without

    Maybe I can do it with any script

    Thanks

  • I use the script here to transfer logins and passwords;

    http://support.microsoft.com/kb/918992/en-us

  • I can confirm that this is the way to do it - from experience.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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