SSL on SQL server

Subash P

10y978

anyone please help me and guide me. i'm new to SSL

how you enable SSL on SQLserver? and how to use .net application with the ssl SQL server.

Thanks in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Accepted answer
There are two things about encryption with respect to SQL Server.
1/ Encrypt sensitive personal data in particular column(s) in particular table(s), for example, social security number (SSN) or date of birth, email address, etc.
2/ Encrypt the data transferred between client and server. This is identical to what happens between web-server and browser when we access https:// (secure) web-sites.
It is assumed that your question is about point 2 above. If yes, there are two ways to go about it.
a/ You can have a self-signed certificate and use it.
https://devcenter.heroku.com/articles/ssl-certificate-self
OR
b/ You can get a certificate from a certificate authority. - It is a slightly complicated process - just like getting your passport from a local authority.
The list of certificate authority is given here:https://en.wikipedia.org/wiki/Certificate_authority
+2
Subash P10y ago
Thank you Nitin sir.
0
Subash P10y ago
Thanks Midhun.
and tell me about certificate? What type of certificate it is? and from where i needs to download?
0
Midhun Tp10y ago
Hi,

Please follow below articles-
https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx
https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/
https://support.microsoft.com/en-in/kb/316898
0