Transfer logins from one MSSQL Server to another

I have two different servers. I need to transfer the logins from one server to another. The logins on the first server are being used by a database on that server and I need to make those logins available to a database with a different name on the second server. Any thoughts?

Who is Participating?
johnc650Connect With a Mentor Commented:
Use the "Transfer Logins" task in DTS...

Its quick and easy!!

insert sp_helpuser into a temporary table


generate sp_grantlogin
and sp_grantdbaccess
statements from the temporary table

then paste and run them in query analyser on the second server...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.