Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to back up and restore security user login [database logins] from sql 2000 to sql 2005 x64 Expand / Collapse
Author
Message
Posted Tuesday, June 17, 2008 12:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 18, 2010 5:25 AM
Points: 2, Visits: 15
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
:)
Post #518031
Posted Tuesday, June 17, 2008 2:00 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598
You can make use of sp_help_revlogin procedure to perform that,http://support.microsoft.com/kb/246133

- Deepak
Post #518057
Posted Tuesday, June 17, 2008 7:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:12 AM
Points: 1,030, Visits: 2,796
You could also script out the logins and users from the 2000 server and run the script on the 2005 instance.

Gethyn Ellis

gethynellis.com
Post #518210
Posted Tuesday, June 17, 2008 9:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 18, 2010 5:25 AM
Points: 2, Visits: 15
thanks deepak....
Post #518395
Posted Tuesday, July 22, 2008 1:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 15, 2009 8:18 AM
Points: 1, Visits: 24
Thank you Deepak, it helped me too !
Post #538793
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse