SQL Server Performance

Mirroring Certificate Expiration Question

Discussion in 'SQL Server 2005 Database Mirroring' started by Ann, Jan 31, 2008.

  1. Ann New Member

    I have done Sql Server Mirroring 2005 in production environment and is working fine since 1 yr.While creating certificates I did not mention any dates for expiration.Read on the web that if we do not specify any expiration dates for certifiacate it is 1yr by default.How can I extend the expiration date as the certificate expiration is due on Feb 20.I also read that if the certificate expires the users are locked out and since it is in the production environment I am very much concerned.
    If anyone has any suggestions on how to extend the certificate expiration date.
  2. MohammedU New Member

  3. satya Moderator

    You need to ensure that all of the SQL Servers you are using for the mirroring configuration are synchronized in terms of time i.e., the system time is same. Otherwise, you will get into this situation which can result in a cert being considered as expired

Share This Page