SQL Server Connection using SSL

[ChaseP]

I am currently using an encrypted connection to a SQL Server database. I am able to do this by  appending "encrypt=true" to my connection string and using a .pem file that I am able to apply using the Microsoft management console. 

http://www.sqlservermart.com/HowTo/Windows_Import_Certificate.aspx

Is there another way to dynamically import a security certificate or set it using the LabView Db connectivity toolkit?

[MoviJOHN · Accepted solution]

Almost everything you can do in the MMC plugins can also be done from the command line in Windows.  You just need to find the proper set of commands, and use the System Exec VI to implement your solution.

http://technet.microsoft.com/en-us/library/cc732061(v=ws.10).aspx

[ChaseP]

This works but the only downside is I have to install the Windows Driver Kit 8.1. I am hopeing if I include the .NET 4.5 installer that certmgr.exe will still work.