Solved

Transfer logins from one MSSQL Server to another

Posted on 2003-11-11
2
181 Views
Last Modified: 2006-11-17
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
Comment
Question by:medium_grade
2 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 9725048
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
 

Accepted Solution

by:
johnc650 earned 250 total points
ID: 9726363
Use the "Transfer Logins" task in DTS...

Its quick and easy!!

-jfc-
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now