question

DesmondLimSS-2550 avatar image
0 Votes"
DesmondLimSS-2550 asked AmeliaGu-msft answered

SQL Server SSL Connection

Hi, Is SSL connection necessary if my DB and application are both in the same host ?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

SSL = "Secured Socket Layer" is an encrypted connection, e.g. for connection between different server or more if over internet.
But if all is running on one server, then it's not that important.

See Enable encrypted connections to the Database Engine


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DesmondLimSS-2550 avatar image
0 Votes"
DesmondLimSS-2550 answered

Hi,

Is it still relevant if both the application and the SQL Server are in the intranet ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi DesmondLimSS-2550,

Is it still relevant if both the application and the SQL Server are in the intranet ?

Do you mean the application and the SQL Server are in the intranet and in the same host?
If so, I think SSL encrypted connection is not very necessary as Olaf mentioned.
If the application and the SQL Server are in the intranet and in the different server, I think it is better to enable encrypted connection. SSL can prevent unwanted sensitive data leak, or exclude the possibility for any SQL injection attack, and a network packet sniffer cannot read the data. Please refer to this thread which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.