October 17, 2005 at 2:49 am
Hello,
Today's question is easy, i believe, but still difficult for a newbie like me. I'm triying to install SSL encryption on my SQL Server and i've noticed a "strange" behavior when y test if data is encrypted. I installed the server certificate on my SQL server machine and enabled the "Force Protocol Encryption" in the Server Network Utility. Then i added to a client station the CA path for the CA i used to make the server certificate. I'm using query analyzer and network monitor to test connectivity and encryption, but i've seen tha even when i delete the CA path certificate from the client machine i'm able to connect to the SQL Server and make queries without any problem. My question is, is that correct?, i think without the CA path certificate i shouldn't be able to connect with the server...am i wrong?
Regards,
J
October 20, 2005 at 8:00 am
This was removed by the editor as SPAM
October 20, 2005 at 9:57 am
When you say you're deleting the CA path from the client, what exactly do you mean? Are you saying you're removing the CA's certificate from the certificate store either under Trusted Root CAs or Intermediate CAs? If so, is it possible that you're only doing so for your user account but the computer's store itself the CA's certificate?
K. Brian Kelley
@kbriankelley
October 21, 2005 at 1:04 am
Hi Brian,
Yes, that is what i've done, but i'm sure that not for my user but for the computer account.
Regards,
October 21, 2005 at 1:17 am
Did you restart SQL Server after installing and configuring the certificate?
Joe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply