How to change encrypted password for SQL standard account

From: royzm001 (royzm001@yahoo.com)
Date: 08/30/02 

From: royzm001@yahoo.com (royzm001)
Date: 30 Aug 2002 07:46:29 -0700

I have two servers, where SQL Server standard logins has to be in
synch all the time. I can run sp_help_revlogin (see Q246133) to create
script, which will create logins. Run that script on secondary server
and it will create all logins with same sid and password as on first
server. The account on secondary server is created with sp_addlogin
@encryptopt = 'skip_encryption'. Now user changes password on primary
server. Unfortunately the sp_password does not have same @encryptopt
parameter. It is possible to add one, but I am looking for MS
supported procedure to do same thing as sp_addlogin is doing with
@encrypopt but for sp_password.

Please, let me know if there is any way to update password on existing
account, if only encrypted password is available.

Relevant Pages

  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... I finally discovered that there was a whole folder structure under ... Event viewer shows normal logins, but I did not have it set to record ... there are a bunch of logins for Website Accounts created by the ... order to find those files on the Web Server I had to make sure that System ...
    (microsoft.public.windows.server.networking)
  • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
    ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
    (microsoft.public.exchange.admin)
  • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
    ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
    (microsoft.public.exchange2000.protocols)
  • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
    ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
    (microsoft.public.exchange2000.admin)
  • 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)