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

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: Monday, April 21, 2014 10:39 AM
Points: 214, Visits: 568
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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:20 AM
Points: 32,819, Visits: 14,966
search sp_help_revlogin.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
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: Monday, April 21, 2014 10:39 AM
Points: 214, Visits: 568
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: Tuesday, May 31, 2011 12:36 AM
Points: 145, Visits: 67
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: Thursday, August 01, 2013 8:34 AM
Points: 7, Visits: 142
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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:20 AM
Points: 32,819, Visits: 14,966
sp_help_revlogin :)






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #473667
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse