Replicate Login Account from 2005 to 2005 Sql Server

• Stubby Bunny

  SSCommitted

  Points: 1733

  More actions

  February 3, 2009 at 11:46 am

  #383856

  I have googled the heck out of this and cannot find a good answer. SSIS was not installed on either server by previous workers. How can I copy the login accounts from one SQL server to another SQL server. I also need to replicate Jobs as well on the other server. What is the best practice to accoumplish this. thank You

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 3, 2009 at 12:05 pm

  #937418

  For passwords:

  http://support.microsoft.com/kb/246133

  Jobs:

  Script them out and apply them on the Target Server!

  
  * Noel