Post reply

The certificate 'cert1' is not valid for endpoint authentication. The certificate must have a private key encrypted with the database master key and current UTC date has to be between the certificate start date and the certificate expiration date.

  • August 28, 2009 at 5:46 am

    #225546

    I want to add a new certificate for Mirorring i get this error message:

    QUERY:

    ALTER ENDPOINT [mirroring] FOR DATABASE_MIRRORING (AUTHENTICATION = CERTIFICATE [SQL2K51_cert_2])

    GO

    RESULT:

    The certificate 'cert1' is not valid for endpoint authentication. The certificate must have a private key encrypted with the database master key and current UTC date has to be between the certificate start date and the certificate expiration date.

    How do i handle this problem.

  • August 28, 2009 at 7:05 am

    #1046166

    Go ahead and drop us following information:

    SELECT * FROM sys.certificates

    SELECT * FROM sys.symmetric_keys

    SELECTis_master_key_encrypted_by_server

    FROMsys.databases

    WHEREdatabase_id=DB_ID('')

    -Lucky

  • August 28, 2009 at 7:22 am

    #1046186

    First I upload certificates,

  • August 28, 2009 at 7:36 am

    #1046203

    Second Symetric Keys and is_master_key_encrypted_by_server data in the attached file.

    My certifaicate expired and i add a new certificate [cert1] but i could not alter endpoint to new certificate.

    Regards.

  • August 28, 2009 at 7:36 am

    #1046204

    Could you run those three commands in your database and send us the result?

    -Lk

  • August 28, 2009 at 7:40 am

    #1046210

    Results are above, three reply, I could not attach files as an e-mail attachment.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply