I am setting up a database mirroring in SQL server 2005 SP2 .The issue is when I create endpoint on any of the servers, after creating the certificate I am getting the following error message
Msg 28055, Level 15, State 5, Line 3
The certificate 'xxx' 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.
What does this means ?
I have solved this by changing the system date to a day before when creating certificate after changing the date I create certificate and then I can create endpoints without this error .
Is there any mistake in my steps?