|
|
|
SSC 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
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166,
Visits: 6,925
|
|
|
|
|
|
SSC 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
|
|
|
|
|
SSC-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
|
|
|
|
|
Forum 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.
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166,
Visits: 6,925
|
|
|
|
|
