Solved

SQL Server: Moving User Accounts?

Posted on 2006-10-24
6
862 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.

757 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