Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to set up a MS SQL 2000 server to use an already existing SSL certificate installed on the server.

I verified that the certificate shows up in the Personal/Certificate folder of the account that is running the MSSQLSERVER service using the Certificate MMC snap-in.

I also verified that the certificate for the CA is installed under the Trusted Root Certificate Authorities.

Additionally, to make sure that it is using this specific certificate I created a Certificate registry value of type REG_BINARY in:


and I set it to the certificates thumbprint like it mentions in:

Finally, I opened up the Server Network Utility, checked Force protocol encryption, clicked OK, and restarted the MSSQLSERVER service.

Unfortunately, it fails to start and looking at the event log it's failing with:

Encryption requested but no valid certificate was found. SQL Server terminating.

I'm at a loss. Any ideas? Where did I go wrong?

share|improve this question

Make sure your "issue to" for the certificate matches exactly as the FQDN of the server you're installing and running SQL Server on. Once it's in the personal store, SQL should start. I had the same issue.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.