?
Solved

SQL: Login and User on sql server 2008 MOVE --> another 2008

Posted on 2014-01-21
2
Medium Priority
?
230 Views
Last Modified: 2014-01-21
Good morning,

I have seen quite a few articles on the web on moving login/users from one flavor of sql server to another but don't really see one for 2008.  
If you happened to have scripts or directions then will be greatly appreciated.
thx
0
Comment
Question by:John Esraelo
2 Comments
 
LVL 23

Accepted Solution

by:
Steve Wales earned 2000 total points
ID: 39797471
Straight from MS support explaining how to move logins.

http://support.microsoft.com/kb/918992

If you restore the database from a backup on the new server, users should move with the DB.

If, after doing the restore, you have orphaned users (link from user back to login is broken) you can do this to fix them:

http://technet.microsoft.com/en-us/library/ms175475.aspx
0
 

Author Closing Comment

by:John Esraelo
ID: 39797484
Sweet, thank you
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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…

594 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