Moving Users from 2000 to 2005 1

[LonnieJohnson]

I am in the process of migrating all my databases and such from ss2000 to ss2005. Is there a way to move all the users in the main security node of ss2000 to the main security node of ss2005?

Export/Import?
Script them out on ss2000 and run the script on ss2005?

Help.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[JayKusch]

Well off the top of my head, you could use the SSIS "Transfer Login" task.

Another way would be to use the Copy Database Wizard.

Both of these can be found in SS2K5 Mgt Studio.

And if you need to keep the SIDs linked between the logins and the databases, you may want to take a look at the following link:

http://msdn.microsoft.com/en-us/library/ms137870.aspx

Thanks

J. Kusch

 

[mrdenny]

Google for sp_help_revlogin. Put this procedure on your SQL 2000 server and run it. It will output a SQL Script which you can run on the SQL 2005 server to create the logins with the correct passwords and sids.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[JayKusch]

Nice!

Thanks

J. Kusch

 

[LonnieJohnson]

Not only was this Nice! But it was totally Awesome!!!

Worked like a charm. Thanks a million. Just what I was looking for.

I don't know what Tek-Tips is paying you but it's not enough. :-D

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[mrdenny]

If only they were.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog