Transfer logins 2008->2008

• suvorav

  Ten Centuries

  Points: 1085

  More actions

  February 12, 2010 at 8:39 am

  #216753

  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

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  February 12, 2010 at 8:46 am

  #1118078

  I use the script here to transfer logins and passwords;

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

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  February 13, 2010 at 4:27 am

  #1118410

  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/