?
Solved

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

Posted on 2014-01-21
2
Medium Priority
?
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

771 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