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