Solved

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

Posted on 2014-01-21
2
226 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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query (lookup) 8 64
export sql server dbs 2 26
How to use Recordset, returned from a SPROC as the recourdsource of a form. 24 51
SQL Query 9 27
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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

734 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