We'll my problem is getting the certificate to even show up in the protocols window. :(

>Hi Bob,
>
>Not sure if this is of any help.
>
>When I tried to do this to check an encrypted ODBC connection I installed the certificate but then I think I just used Configuratiuon Manager, properties of the protocols, to Force Encryption on the SQL Server itself.
>
>I used Netmon to catch the packets and confirm the packets could no longer be read.
>
>Jon
>
>
>>I have SQL Express 2005 running on my Vista machine as a development environment. I'd like to test the ADO connection setting of .Encrypt = true; in my C# application.
>>
>>I've used MakeCert.exe to create a self-signed certificate, and have added the certifcate to the Trusted Root Certifcate Auth using the CertMgr.exe. Now the next trick is to be able to select the certificate on the Protocols for SQL Express in the Configuration Manager. But after installing the certificate, I can't see any certificates in the protocols dialog.
>>
>>Can anyone give me guideance? The help button on the Protocols window says:
>>
>>To load a certificate for use by SQL Server, you must be running SQL Server Configuration Manager under the same user account as the SQL Server service. I am an administrator on my Vista PC and I set the SQL Service to run under my credentials, but still I can't see any Certificates.
>>
>>Thanks in advance for any help you can provide!!
>>
>>bob