From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Configure encryption for connections - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure encryption for connections
- [Instructor] When it comes to securing your data through encryption, it's not enough to encrypt the data at rest, you need to encrypt it in transit as well, especially if those connections occur over the internet. That's why making sure that you're communicating with remote users through encrypted connections comes into play. SQL Server uses SSL or Secure Sockets Layer to encrypt data that is sent across a network between a host SQL server instance and a connected client. It does this through the use of a certificate and if you remember, that means that the public portion of an asymmetric key is sent to the client to be used to encrypt and decrypt communications with the server. The private key is retained by the server to do the same when communicating with the client. The use of a certificate comes with an additional advantage over simply generating a basic asymmetric key. Certificates ensure that the client can confirm the identity of the server that they're communicating with…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.