Post reply

Transfering Login's between sql2000 and sql2005

  • January 14, 2009 at 10:27 am

    #199998

    I restored a sql2000 database onto a server using sql2005. The restored database is under a new name. What is the best way to transfer the logins into the sql2005 server?

    I discovered "who"

    still looking for "why" and "how"

    Can I buy a vowel?

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

  • January 14, 2009 at 10:32 am

    #926746

    There is a script to do just this on the microsoft site look for sp_helprevlogin in google

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 14, 2009 at 10:36 am

    #926753

    You could do this by using DTS package with logins transfer option or else you can do with this store procedure. I had done both ways successfully.

    Go through this page: http://support.microsoft.com/kb/246133

    SQL DBA.

  • January 17, 2009 at 3:26 pm

    #928767

    sp_helprevlogin

    also check for orphaned users when you are done.

  • January 20, 2009 at 9:44 am

    #929782

    Yes, Thank you. The process seems to have worked fine. It seems that upgrading databases is getting easier than it used to be.

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

  • September 23, 2010 at 11:10 am

    #1226474

    The issue wasn't the scripits they work te problem was the authentifiation mode it was set to NT only...

    Dumb dumb dumb

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

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