How to setup my connection string to communicate SQL server with encryption?

The below example specifies the use of encryption, Essentially you are using the connection string from the SQL SQL server to be encrypted.

<connectionStrings> 
<add name="MyConnection" connectionString="Data Source=tcp:sql1001.smarterasp.net;Initial Catalog=DB_XXX_db1;User ID=DB1_user;Password=*****; encrypt=true;TrustServerCertificate=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

SQL server- network related or instance-specific error happened while connection establishing

  Instance-specific or network related error happening while connecting to SQL server   Please...

OleDB connection string examples

OleDB connection string examples MS Access (Jet) "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA...

Do you allow custom COM components?

Do you allow custom COM components? We are not offering to install the custom COM components...

Error when accessing a WCF services

Error when accessing a WCF services Error when accessing a WCF service: "IIS specified...

How to cache static contents to client with UseMaxAge?

You can consider to caches static contents to the client with UseMaxAge if your website has too...