December 25, 2007 at 10:51 pm
hello guys, i just want to ask how to transfer all users from old sql server to new sql server.
December 25, 2007 at 11:23 pm
Hi
One of the ways to do it would be to script the logins&users from the old server and run the script in the new server.
"Keep Trying"
December 26, 2007 at 9:53 am
First, please post in the appropriate forum for your version. I'll move this to the 2005 forums for now.
Second, search for sp_help_revlogin and you can use that to move logins. Logins are at the server level. Users are per database. To move them, you can easily script them out.
December 27, 2007 at 8:48 am
How to transfer the logins and the passwords between instances of SQL Server 2005
http://support.microsoft.com/kb/918992
--
How to transfer logins and passwords between instances of SQL Server
(covers SQL Server 7.0 to 2005 (9.0))
http://support.microsoft.com/kb/246133
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
December 27, 2007 at 1:36 pm
i never had a chance to test the script and was always afraid to run it for real at 2am. so we always did it manually.
to speed things up i have a pre-made script with sp_something userslogin to map a login back to a db user for every login we have in existance.
copy and paste from a spreadsheet into sql, than run the script for each login and i'm done
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply