SQL Server Performance

Certificate in mirroring expired

Discussion in 'SQL Server 2005 Database Mirroring' started by WingSzeto, Apr 2, 2008.

  1. WingSzeto Member

    Hi,
    The certificate I created for the mirroring has expired. When I checked the certifcate, it was valid from March 23 2007 to March 24 2008. I didn't realize the expiration until I rebooted the server today and getting a lot of error about logon failed using certificate in the SQL error log. Do I have to redo the mirroring or can I recreate a new certifcate? If so, how do I recreate a new certificate or how can I extend the expiration date to like no expiration?
    wingman
    WingSzeto, Apr 2, 2008
    #2

  2. ghemant Moderator

    ghemant, Apr 3, 2008
    #3

  3. WingSzeto Member

    The link is very helpful and I was able to fix the expiration problem.
    Thanks...
    wingman
    WingSzeto, Apr 3, 2008
    #4

  4. ghemant Moderator

    Glad to know it helps you :)
    ghemant, Apr 4, 2008
    #5

Share This Page