SQL Server: Moving User Accounts?

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!
Jinghui LiAsked:
Who is Participating?
 
AaronAbendCommented:
SQL 2000 or 2005?

http://www.support.microsoft.com/?id=246133  for 2000
0
 
Jinghui LiAuthor Commented:
Thanks for your quick response.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
doobdaveCommented:
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
 
Jinghui LiAuthor Commented:
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
 
doobdaveCommented:
No problem  :o)

The important thing is you got the answer you needed.

Best Regards,

David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.