dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
499

DarkLogix
Texan and Proud
Premium Member
join:2008-10-23
Baytown, TX

1 edit

DarkLogix

Premium Member

SQL and SSL certs

I setup a SQL server at home and want it to use a SSL cert but I can't get it to take.
the dropdown just remains blank on the part where you select the cert.

Everything I've read seems to say it should be working.

any tips or tricks?
its SQL2014 on server 2008R2
with SQL running with a domain service account.
DarkLogix

DarkLogix

Premium Member

I got it working with a new cert template without a SAN and the sub was the DNS name (FQDN form) and a keysize of 4096

not sure if the keysize was an issue but didn't feel like editing the template again to set it to 16k like my other internal certs now that this one is working.

Also had to set the SPN attribute on the service account to get the SSMS to connect securely.