Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thelostleaf
Starting Member
4 Posts |
 Posted - 2010-08-16 : 12:47:25
|
| Hi, I've searched everywhere for a decent article on Encyption while transported over the network / internet. I'm figureing its some SSL setup but I can't seem to find a solid scenario.I have a windows client that gets a regular connection string for access to a remote SQL DB and want it encrypted while transport. This is an app for distribution, so ease of install is importatnt.Thanks For any direction.. |
|
|
thelostleaf
Starting Member
4 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-16 : 14:54:05
|
| SSL. or you can have them connect over VPN |
 |
|
|
thelostleaf
Starting Member
4 Posts |
Posted - 2010-08-16 : 15:44:20
|
| VPN may be the best bet, it seems to be a pain in the rear to set up SSL easily, but I have made progress and will report back. |
|
|
|
thelostleaf
Starting Member
4 Posts |
Posted - 2010-08-16 : 16:44:01
|
| After running through the MS Sample link earlier in this post I was able to connect with SSL by using these parameters in my conn string, encrypt=true; trustServerCertificate=true;I used the certificate of my FQDN which is a DC, when configuring with the SQL Server Config Manager. I had to export that cert also before it was visble in the SQL cert dropdown.It appears unless your connectionstring says encrypt=true; you can still connect to the instance without SSL being used even though Force Encrypt is set to true in Protocols.(Here is a thread outlining scenarios)http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/aa72c08b-6bd7-4e71-99fc-185859885f2d |
|
|
|
|
|
|
Windows app with Remote SQL DB - Encrypt Transit