RE: Changing SQL Atuhthentication passwords

From: Kevin McDonnell [MS] (kevmc@online.microsoft.com)
Date: 04/02/03

  • Next message: Kevin McDonnell [MS]: "RE: Firewall and Intrusion detection" 
    From: kevmc@online.microsoft.com (Kevin McDonnell [MS])
Date: Tue, 01 Apr 2003 22:11:43 GMT

    It sounds like you're relying on a duplication of nt user id's and
    passwords. If the NT users passwords expire, then they would have to be
    re-synched on both machines. There is no way around this.

    If you're asking about changing a SQL logins password, then the previous
    post is correct. Just use sp_password and incorporate it into your
    application.

    Thanks,

    Kevin McDonnell
    Microsoft SQL Server

    This posting is provided AS IS with no warranties, and confers no rights.

    10 things you can do today to improve the security of your SQL Server
    installation:
    http://www.microsoft.com/sql/techinfo/administration/2000/security/securings
    qlserver.asp

  • Next message: Kevin McDonnell [MS]: "RE: Firewall and Intrusion detection"