I’m trying to install a certificate on a SQL2005 server as we need to secure communications between our server and a 3rd party.
IIS isn’t installed so I’ve used certreq to generate the CSR, and have purchased an intranet SSL certificate from Comodo.
The certificate name matches the FQDN of the server and has been installed as a computer certificate in the Personal store.
The server has been restarted since installing the cert.
When I’m in SQL Server Config Manager > Protocols for SQLEXPRESS properties > Certificate tab, I do not have the option to select the certificate that I’ve installed.
In some of the many docs I’ve read, it has been suggested that you can manually update the reg key: HKLMSoftwareMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServerSuperSocketNetLibCertificate – although I’ve not had much luck with this.
The SQLExpress service is running as a network service – does it have to be Local System?
I hope someone can shed some light on this – thanks in advance!
You must be logged in to reply to this topic.
Create a free account today to participate in forum conversations, comment on posts and more.