Post reply

how to back up and restore security user login [database logins] from sql 2000 to sql 2005 x64

  • June 17, 2008 at 12:22 am

    #208458

    Hi Group,

    I have a database in SQL Server 2000 Standard Edition, I am now migrating that into SQL Server 2005 SP2 x64.

    I have atleast 50 database users login with the database, can anyone help me how to take backup and restore the database logins so that i can see these in the security logins under object explorer of SQL Server 2005's Management studio. I noticed that these logins shows in the database's Security Logins but not in SQL Server's Security Logins.

    Now what how can i restore the complete set of those 50 users.

    Advance thanks

    regards

    🙂

  • June 17, 2008 at 2:00 am

    #829629

    You can make use of sp_help_revlogin procedure to perform that,http://support.microsoft.com/kb/246133

    [font="Verdana"]- Deepak[/font]

  • June 17, 2008 at 7:16 am

    #829753

    You could also script out the logins and users from the 2000 server and run the script on the 2005 instance.

    Gethyn Elliswww.gethynellis.com

  • June 17, 2008 at 9:51 am

    #829901

    thanks deepak....

  • July 22, 2008 at 1:25 pm

    #846665

    Thank you Deepak, it helped me too !

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

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