Re: Log Shipping Passwords

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/05/04

  • Next message: Tibor Karaszi: "Re: Extending segments in syslogs" 
    Date: Sat, 5 Jun 2004 08:27:52 +0200

    Why not use sp_help_revlogin so you re-create the logins on the other end with same sid and password, and you
    don't have to worry about any synchronization of users? 

    -- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Oberlin" <johno@-nospam-callow.ca> wrote in message
news:1036BDF6-EBF0-4235-8265-B4BC2EBEEC4B@microsoft.com...
> I am trying to transfer my SQL logins from the primary
> server and resolve the passwords on the secondary
> server.  I have the log shipping setup as per TechNet's
> article:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/main
> tain/logship2.mspx
>
> i.e.
> 1.  Running sp_resolve_logins to populate the sysxlogins
> in master.
> 2.  Running sp_change_users_login to link the transferred
> and resolved logins with their corresponding database
> users and permissions
>
> The very first time I transfer the logins everything
> works fine.  If people change their passwords I want to
> be able to run this regularily to refresh the logins and
> update the secondary server with the new passwords.  This
> is not happening.  The secondary server still has the old
> passwords.
>
> Thanks in advance.  Any help would be appreciated.
>
> John
>
>
  • Next message: Tibor Karaszi: "Re: Extending segments in syslogs"

    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)
    • Moving logins to new server ???
      ... >backend from an old server to a totally new one. ... >The website database uses SQL authentication to grant ... >There are HUNDREDS of logins. ... >sever, complete with passwords? ...
      (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)
    • Re: Blacklisting IPs
      ... if the attempts come from varying IPs and you intend to allow ... logins from the Internet, then you'd need to block out an unwieldy ... Make sure you use strong passwords, or better, try one time ... I use ssh, ...
      (freebsd-questions)
    • 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)