RE: Copy SQL Users from a server to another

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 02:51:21 GMT

Hi Guillaume,

You can transfer logins and passwords between instances following the
suggestions mentioned below:

246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/?id=246133

If there is any thing unclear, please feel free to let me know.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • RE: Linked Server setup problem
    ... Transfer Logins and Passwords Between Instances of SQL Server ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL2000 accounts to SQL 2005 ?
    ... "Hank Arnold " wrote in message ... You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005. ... You transfer logins and passwords from SQL Server 2000 to SQL Server 2005. ...
    (microsoft.public.sqlserver.setup)
  • RE: Windows 2003 Migration. Impact on security(windows authenticat
    ... Transfer Logins and Passwords Between Instances of SQL Server ... newsgroup Microsoft.public.sqlserver.security, ...
    (microsoft.public.windows.server.sbs)
  • Re: Login migration
    ... Transfer Logins and Passwords Between Instances of SQL Server ... "Chris" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: How to RESTORE USERS PASSWORDS in MS SQL 2K when you restore db from a bkup?
    ... Can you give them an arbitrary password that they will set the first time they log in? ... Transfer Logins and Passwords Between Instances of SQL Server ... > I meant even me should not know about the users passwords, in event of restoring a database I am not allowed to create new passwords. ...
    (microsoft.public.sqlserver.server)