• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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?

--Dave
0
medium_grade
Asked:
medium_grade
1 Solution
 
LowfatspreadCommented:
insert sp_helpuser into a temporary table

then

generate sp_grantlogin
and sp_grantdbaccess
statements from the temporary table

then paste and run them in query analyser on the second server...
 
0
 
johnc650Commented:
Use the "Transfer Logins" task in DTS...

Its quick and easy!!

-jfc-
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now