The post is to demonstrate how to encrypt connection to SQL Server using SSL. At the bottom of the page you can see the video which demonstrates how to create a certificate and configure SQL Server to use SSL.

SSL : Secure Sockets Layer is the most commonly used for web based client or native SQL Server Clients.

Lets see how can we obtain a certificate using IIS. Folow the below steps

• Open IIS Manager
• Click on the Root (Server Name) under connections
• On the Right Panel window select Server Certificates under IIS
• Double Click Server Certificates
• Under Server Certificates right click and select Create Self-Signed Certificate.
• Provide a friendly name for the Certificate and select the Certificate Store for the Certificate
• Click OK

Certificate is created and installed. Now Configure the SQL Server to use the Certificatesql

• Start SQL Server Configuration Manager and Navigate to SQL Server Network Configuration
• Select Protocol for <SQL Server Instance Name>
• Right click the Protocol>Properties>Certificate Tab
• Choose the Certificate just created.
• Go to Flags tab of the Property Page
• Select Yes for Force Encryption
• Click Apply and OK

Now Restart the SQL Server Services for the change to take effect