5 pts.
0
Q:
Migrate User & Permissions SQL 2000 to SQL XXXX
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
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
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
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