Re: Error 28055 when creating mirroring endpoint.

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:346EF8CB-35F7-4CEF-8DD0-7A38DBCC87C8@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: ADFS Token-signing Certs Not in Trusted Root Store
    ... This is good info, Joe. ... So now I know that the token-signing certificate is ... Get a signing cert from a CA ... case, you never have to worry about expiration or CRL checking, as your cert ...
    (microsoft.public.windows.server.active_directory)
  • Re: Issues with SSL on Win CE 5.0
    ... the HKCU certificate store. ... and tell the web server to use it. ... The old cert was in. ...
    (microsoft.public.windowsce.embedded)
  • Re: Accessing certificate store from ASP.NET web project
    ... the cert must be in the local computer/personal) store - it will then open ... Have a look at the source code to open the right cert store... ... One of the locations requires a x509 certificate in order ... different user context than my vb.net web project. ...
    (microsoft.public.dotnet.security)
  • Re: Web Certificate for IIS Server on SBS Domain
    ... Before your reply, I actually ran across rapidssl myself, and have ordered and installed the free 30-day certificate on my site. ... I explained what you'd told me about putting my existing configuration at risk by installing Cert Services, and he said he didn't know that. ... Again, if you're just needing a cert to install on your web server to provide SSL connectivity for remote users, go with an external third-party provider. ... When you add Certificate Services on an internal network, lots of internal communications will start using pieces provided by the Cert Server instead of the defaults from Server 2003, and when things blow up, they can blow up gloriously. ...
    (microsoft.public.windows.server.sbs)
  • Re: Dummies Guide for RADIUS/Certs
    ... I have set up IAS. ... client computers impacts certificate enrollment. ... configure Group Policy for domain member wireless clients so ... Cert Templates that is now enrolled on the IAS server. ...
    (microsoft.public.internet.radius)