How to add SSL certificate and key files to xDataServer for HTTPS support.

Hi @Jitendra_Gouda. First, thank you for the detailed post.

Indeed, it looks like a problem with your certificate. It's not related to TMS Sparkle as you saw that even in netsh it is not working. And, yes, one of the problems might be that your certificate does not have a private key, so you will have to regenerate it and make sure it includes the private key.

But there might be other reasons as well. Here is one nice answer from Stack Overflow:

  • The SSL cert is corrupt - you need to delete from the cert store and re-add.
  • The SSL cert is lacking a private key - you need to delete from the cert store and re-add the full public/private cert, or otherwise attach the private key to your certificate.
  • If installing on a pre-SP1 version of 2012R2, you may need KB 981506.
  • You may have added the SSL cert to your user store, and not the local machine cert store - delete from the user store and add to the machine store.

But there are plenty of discussion and possible solutions out there: