Valid certificate not found while enabling Replication for SQLDB

Asked By Wood Rebeca 0 points N/A Posted on - 09/14/2012

Hi guys,

While enabling Replication for SQLDB in the Connection Parameters, it did not find valid certificate. I went through the details, but understood nothing. Look at the screenshot given below.

Select certificate

No valid certificate found

A valid certificate for replication should have the following

properties:

1. Certificate should not be expired.

2. It should have Client Authentication EKU, and an associated

Private Key.

3. It should terminate at a valid root certificate.

4. The subject common name (CN) should be equal to, or

subject alternative name (DNS Name) should contain,

PriBroker.FRTEST.nttest.microsoft.com.

Install a valid certificate and try again.

See details                                                  Close

If you have any idea regarding this issue to fix, please help me.

Please help.

• Status: Open
• Question Views: 1239
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Aurtt munguia 0 points N/A #151458

Valid certificate not found while enabling Replication for SQLDB

It's a problem with the certificate which could be caused by many reasons:

1)  The certificate should be located on the local computer or in the current user store.

2)  It's mentioned in the error message that the certificate shouldn't be expired which means that the system time should be in the (valid from -> valid to) time interval . You can try to change the system time and try again. "It's the most common reason so you should give it a try."

About Aurtt munguia

Questions
1

Answers
66

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 11/23/2012
• Question Category: Misc Software