Solved

Transfer logins from one MSSQL Server to another

Posted on 2003-11-11
2
182 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is format f12.8 for a CSV file 6 41
Help with Sorting Full Text results 2 14
Sql Count with Select Distinct 4 27
SQL VIEW 7 23
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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…

896 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

17 Experts available now in Live!

Get 1:1 Help Now