users in SQL server? urgent plz!!

[parsql]

Hi all,

I reattached database from on server to another server but need to transfer users too? which way i can do that?
do i have to restore master for that?

 

[mrdenny]

There are a few methods you can use.

1. Restore Master from the old server.
2. Manually create the logins.
3. Search Microsoft's web site for sp_help_revlogin. This is a proc that you can download and deploy to the old server which will script out all the NT Logins and SQL Logins so that you can recreate them.
4. Use DTS to transfer the logins via the login transfer task.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com