Home > IT Answers > SQL Server > Migrate User & Permissions SQL 2000 to SQL XXXX
Njimenez
5 pts.
 Migrate User & Permissions SQL 2000 to SQL XXXX
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005
Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

Software/Hardware used:
ASKED: June 25, 2009  4:26 PM
UPDATED: June 25, 2009  5:20 PM
RELATED QUESTIONS
Answer Wiki:
Google for sp_help_revlogin. This script from Microsoft will export the users and passwords and allow you to create them on the new server. You can then attach the database from the SQL 2000 server to the new server and the logins will all match the users in the databases.
Last Wiki Answer Submitted:  June 25, 2009  4:57 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hello Doctor.

Here is the link:

How to transfer logins and passwords between instances of SQL Server

You should use the script from Method 2.

Cheers,

carlosdl
 63,535 pts.