I am using the following references:
and others which give the same information. I have installed the trusted certificate into the Personal folder using the Microsoft Management Console. It works fine for HTTPS and secure FTP. However, when I try to enable SSL encryption on SQL Server 2008 R2 Express, the certificate does not show up in the certificates tab when I expand the SQL Server Network Configuration protocols, select properties and then select the certificates tab. It does show up in the personal folder of the certificates store. Is this because I'm using the express edition or something else? I appreciate suggestions on how to remedy this problem or definitive evidence that I'm wasting my time.