Moving logins to new server ???

From: Ashish (anonymous_at_discussions.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 13:16:49 -0700

Run following to create scripts on primary. Copy scripts
from Primary and run on secondary server to create logins
with passwords

select 'EXEC sp_addlogin @loginame = ''' + name + ''''+
', @passwd = "' + coalesce(password,' ') +
'", @encryptopt = skip_encryption' +
', @sid = ' ,sid
from master..syslogins

>-----Original Message-----
>Working on migrating a database used for a website
>backend from an old server to a totally new one.
>The new server already has some production databases
>running on it.
>The website database uses SQL authentication to grant
>access to procedures/data on a per website user basis.
>(i.e. user logs onto website over SSL with their SQL name
>and password which is then used by ASP for any database
>interaction)
>There are HUNDREDS of logins.
>
>Is there any way to move or copy these logins to the new
>sever, complete with passwords?
>If not, are there other options that don't involve
>assigning everyone new passwords?
>
>Thanks.
>.
>

Relevant Pages

  • Re: Transferring logins form 6.5 to 2000, anyone?!
    ... > server is case-insenstive, and the 2000 server is case-sensitive, then you ... > end up with all your passwords in upper case when they're copied. ... > /* Get 6.5 login information into the worktable, excluding system logins. ... >> Microsoft Online Support Engineer ...
    (microsoft.public.sqlserver.security)
  • Re: login password changed
    ... available from Microsoft (reference Knowledge Base Article 246133). ... executed on the target server to create the logins with their original SIDs ... The passwords after transfer ...
    (microsoft.public.sqlserver.server)
  • Log Shipping Passwords
    ... I am trying to transfer my SQL logins from the primary ... server and resolve the passwords on the secondary ... If people change their passwords I want to ...
    (microsoft.public.sqlserver.setup)
  • Re: Log Shipping Passwords
    ... Why not use sp_help_revlogin so you re-create the logins on the other end with same sid and password, ... Tibor Karaszi, SQL Server MVP ... If people change their passwords I want to ... > update the secondary server with the new passwords. ...
    (microsoft.public.sqlserver.setup)
  • Moving logins to new server ???
    ... The new server already has some production databases ... The website database uses SQL authentication to grant ... assigning everyone new passwords? ...
    (microsoft.public.sqlserver.security)