SSL setup problems

From: AG (anonymous_at_discussions.microsoft.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 07:51:12 -0800

I am having problems getting SSL to work. I have trawlled through various other posts and knowledge base articles but have run out of ideas. I have a SQL Server the service accounts are running as a local account. I created a standalone CA on another server, i requested certificates from this ca using http (following q276553 instructions) and i can see it correctly using certificates mmc in the personal certificates folder (but i can't see it in IE personal certificates?). The certificate has the correct FQDN name of the sql server. I set the server network option to force encryption (only tcp/ip is used). When this is done the sql services start without error but I can connect using clients which do not have the certificate and using our network sniffing tools can see the data is not encrypted.
 I have looked in the registry as in Q318605 and there was no certificate key. If I add one in and enter the thumbnail of the certificate i get an error when sql starts saying cannot find valid certificate. Does anyone have an ideas as i am pulling my hair out here?

Thanks