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



Moving Sql server 2000 user login and passwords to Sql server 2005 Expand / Collapse
Author
Message
Posted Thursday, March 06, 2008 9:29 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 211, Visits: 490
By simply using the "transfer login task" that can be located in Control Flow in SSIS:D

Imagination is more important than knowledge-Albert Einstein
Post #465281
Posted Thursday, March 06, 2008 10:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166, Visits: 6,925
search sp_help_revlogin.
Post #465354
Posted Thursday, March 06, 2008 11:06 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 211, Visits: 490
First of all, I don't know what has happen to our page here. Its allocation is upside down. Well, lets get to the point. Did you just migrate to 2005? Are you trying to move logins because of that?

Imagination is more important than knowledge-Albert Einstein
Post #465385
Posted Thursday, March 06, 2008 6:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 18, 2010 11:26 PM
Points: 125, Visits: 57
How to move Sql server 2000 user login and passwords to Sql server 2005 environments
Post #465058
Posted Monday, March 24, 2008 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 7:14 AM
Points: 3, Visits: 36
BOL says, "At the destination, the transferred logins are disabled and assigned random passwords. A member of the sysadmin role on the destination server must change the passwords and enable the logins before the logins can be used. "

Is there a way around this? I use mixed authentication and have 1000+ users.


Post #473656
Posted Monday, March 24, 2008 1:06 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166, Visits: 6,925
sp_help_revlogin :)
Post #473667
« Prev Topic | Next Topic »


Permissions Expand / Collapse