Error when creating SQL server 2005 Endpoint
Posted on 2012-09-04
Right now I just move all Db from an old DB, which is mirrored before, to a new server.
When I try to create the new mirror relation I find I need to drop the existing master key and recreate.
but when I try to recreate the end point using this script:
CREATE ENDPOINT Endpoint_Mirroring
STATE = STARTED
AS TCP (
, LISTENER_IP = ALL
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE ccc
, ENCRYPTION = REQUIRED ALGORITHM AES
, ROLE = ALL
I get this error:
"The certificate 'ccc' 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.
Any reason on this and how to fix this ?
What we need to do is just to recreate the mirror ASAP.