Solved

SQL Server: Moving User Accounts?

Posted on 2006-10-24
6
864 Views
Last Modified: 2007-12-19
I am trying to move SQL Server from one server to another. what I plan to do is to backup the database and restore it on the other end.
My question is will this process also take care of all the user accounts associated with the database? If not, is there a convenient way to move user accounts since I have hundreds of accounts on the server. thanks a bunch!
0
Comment
Question by:Jinghui Li
6 Comments
 
LVL 10

Accepted Solution

by:
AaronAbend earned 400 total points
ID: 17796682
SQL 2000 or 2005?

http://www.support.microsoft.com/?id=246133  for 2000
0
 
LVL 20

Assisted Solution

by:Sirees
Sirees earned 100 total points
ID: 17796705
0
 

Author Comment

by:Jinghui Li
ID: 17796738
Thanks for your quick response.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 8

Expert Comment

by:doobdave
ID: 17796758
Hi,

In answer to your question:
Yes the process will take care of all the USER accounts associated with each database.

However, it will not take care of SERVER LOGINS on the database SERVER itself.
The article quoted above will allow you to transfer the LOGINS.

However, you may need to run "sp_update_users_login" in order to too 'fix' the link between the LOGIN and the database USER.
Please refer to the SQL Server BOL for details on using that procedure, you will need to use the 'UPDATE_ONE' option.

Best Regards,

David
0
 

Author Comment

by:Jinghui Li
ID: 17796807
Thanks so much David. Your answer is exactly what I need.
But I have just splitted the points to the other commenters. Sorry, I have no credit for your valuable input this time.
0
 
LVL 8

Expert Comment

by:doobdave
ID: 17801847
No problem  :o)

The important thing is you got the answer you needed.

Best Regards,

David
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 70
What is the proper way to use for criteria in left join? 7 28
Need some help to cast ntext to nvarchar SQL 2000 7 34
Sql Query 6 68
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

831 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