Database Reference
In-Depth Information
The previous operation presents the properties for the selected SQL Server 2008 R2 instance.
In this recipe, our aim is to set the Extended Protection feature on the instance.
5.
As we see in the following screenshot, go to the Advanced tab to select the
appropriate security feature setting:
The Extended Protection value is configured on the
instance level, for this recipe we will choose the two
options that are available: Allowed and Required.
6.
Choose the Allowed option to work for a client operating system that supports
extended protection features. This selection is advantageous if the network is
equipped with a mixed environment where the multiple operating systems are used
by the client applications.
7.
Choose the Required option to work for the client operating system that supports
the extended protection feature. This selection is used to develop the most secure
connection setting to secure the database server.
8.
From the protocol's properties, click on the Flags tab. Select Yes to set Force
Encryption. This option sets a self-signed certificate process that will increase
security, but it does not provide protection against identity spoofing by the server.
Search WWH ::
Custom Search