Results 1 to 6 of 6

Thread: moving users from 2000 to 2005

  1. 10-23-2006, 10:35 AM #1
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188

    moving users from 2000 to 2005

    What is the best way to move users from a 2000 sql server to a 2005 server? I have a bunch of issues with the passwords etc...

    thanks for your time.
    Reply With Quote Reply With Quote
  2. 10-23-2006, 11:28 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use DTS to move user accounts or you can also use sp_help_revlogin procedure.
    Reply With Quote Reply With Quote
  3. 10-23-2006, 11:35 AM #3
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188
    Thanks, I'm assuming i can find that proc on the microsoft site?
    Reply With Quote Reply With Quote
  4. 10-23-2006, 12:03 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Dts copy sql logins task is easier, and every sql2k server has dts.
    Reply With Quote Reply With Quote
  5. 10-23-2006, 01:07 PM #5
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188
    OK, i will try DTS'n users from 2k to 2k5.
    Reply With Quote Reply With Quote
  6. 10-24-2006, 11:24 AM #6
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://support.microsoft.com/kb/246133
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules