Database Reference
In-Depth Information
In the Data Source Properties dialog, you define the type of connection and the
connection properties. Select the “Embedded connection” option, and then
click the Type down arrow. You read earlier that SQL Server 2008 R2 includes
SQL Azure-specific providers, and this is where you find them. As shown in
Figure 8-4, select the new data provider for SQL Azure called Microsoft SQL
Azure (what else are you going to call it?).
When you select this provider, the Connection String text box defaults to
Encrypt=True;TrustServerCertificate=False
Although these two parameters and associated values are defaulted for you, it's recommended that
you not change them. The Encrypt parameter indicates that SQL Server will use SSL encryption for all
data sent between the server and client if the server has a cert installed. The TrustServerCertificate
property tells the transport layer to use SSL to encrypt the channel and bypass walking the cert chain to
validate trust. When both Encrypt and TrustServerCertificate are set to True , the encryption level
specified on the server is used even if the value of the Encrypt parameter in this connection string is set to
False .
2.
Figure 8-4. Data Source Properties dialog
Search WWH ::




Custom Search