Error 28055 when creating mirroring endpoint.

I tried to build a certifictae based endpoint to mirror databases.
However all the time I try to create the endpoint I got the Message:
"The certificta e'MyCert' is not valid fer endpoint authentication. The
certificate must have a privare key encrypted with the database master key
and current UTC date has to be between the certificate start date end
expiration date."
I used the sripts like shown in the example at the help file:
use master
create master key encryption by password ='MyPassword'
go
create certificate 'MyCert' with subject ='Mirroring Certificate',
Expiry_date = '12/31/2020'
go
create Endpoint EPSorry to fast fingers :-)
create Endpoint EP
state=started
as tcp (listener_port=5022, listener_ID=ALL)
for database_mirroring(
Authentication=certificate MyCert,
encryption=required Algorithm AES,
Role=all)
and this create statement will fail all the time
Regards
Michael|||If you live in the eastern hemisphere the newly created cert start date is
not yet valid for a number of hours equal to the difference of hours between
your zone and GMT. So simply specify a start date for the certificate as
well:
create certificate 'MyCert' with subject ='Mirroring Certificate',
Expiry_date = '12/31/2020',
start_date = '02/21/2007';
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Michael W. Schneider" <MichaelWSchneider@.discussions.microsoft.com> wrote
in message news:346EF8CB-35F7-4CEF-8DD0-7A38DBCC87C8@.microsoft.com...
> Sorry to fast fingers :-)
> create Endpoint EP
> state=started
> as tcp (listener_port=5022, listener_ID=ALL)
> for database_mirroring(
> Authentication=certificate MyCert,
> encryption=required Algorithm AES,
> Role=all)
> and this create statement will fail all the time
> Regards
> Michael
>