The connection string below is an example that specifies the use of encryption. Essentially you are using the connection string from the SQL section of your control panel and adding encrypt=true to the end. Setting the encrypt property to true will cause the transmission of data to and from the SQL server to be encrypted.
<add name="MyConnection" connectionString="Data Source=tcp:s01.winhost.com;Initial Catalog=DB_XXX_db1;User ID=DB1_user;Password=*****; encrypt=true" providerName="System.Data.SqlClient"/>
If you run in to problems using this code, please post in our community forum. Technical support cannot assist with specific coding related issues.
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add firstname.lastname@example.org to your trusted senders list in your email software.