How to request certificate for using SQL Server SSL from standalone CA
Posted on 2012-09-21
I would like to test the implementing SSL on SQL server 2005. I have issued the certification from standalone CA on windows 2008 that is used for issuing certificate testing. The issued certificate has details as the following:
Issuer : ca-servername-ca
Valid from :Thursday, September 20,2012
Valid to : Frisay,September 21,2013
Subject : sql-server-name-FQDN
Public key : RSA(1024 Bits)
Enchanced Key : Server Authentication(188.8.131.52.184.108.40.206)
Key Usage : Digital Signature, Non-Repudiation, Key Encipherment,Data Encipherment (f0)
I installed this certificate on windows 2003 in "Computer account" under "Personal" folder. I have tested this certificate by opening, The general Tab shows Red Cross Mark (X) and message "The integrity of this certificate cannot be guaranteed. The certificate may be corrupted or may have been altered"
I opened the properties of insatnce's protocol in the SQL Server manager, it dosn't show the certificate in the certificate dropdown list.
Please advice, what is wrong this certificate