Home > IT Answers > SQL Server > Migrate User & Permissions SQL 2000 to SQ...
Njimenez
5 pts.
0
Q:
Migrate User & Permissions SQL 2000 to SQL XXXX
SQL Server 2000, SQL Server 2000 migration, Upgrade from SQL Server 2000 to SQL Server 2005, SQL Server 2000 to SQL Server 2005 migration, SQL Server migration, SQL Server 2005, SQL Server User Accounts, SQL Server user permissions, SQL Server permissions
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.
ASKED: Jun 25 2009  4:26 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jun 25 2009  4:57 PM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29340 pts.  |   Jun 25 2009  5:20PM GMT

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,

 
0