Log Shipping Passwords

From: John Oberlin (johno_at_-nospam-callow.ca)
Date: 06/05/04 

Date: Fri, 4 Jun 2004 18:01:06 -0700

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

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)
  • 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 ???
    ... >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: VmWare and Pen-test Learning
    ... Setup a tftp server on your client machine. ... Use John the Ripper to crack the passwords. ... (dictionary attacks, brute force, single mode). ... Download FREE whitepaper on how a managed service can help ...
    (Pen-Test)