Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use a packet sniffer to monitor connections made by users to a database. Fortunately, database encryption allows you to protect the data sent over those connections from prying eyes.
Difficulty: Average
Time Required: 30 minutes
Here's How:
- Run SQL Server Configuration Manager.
- Open the SQL Server Network Configuration folder.
- Right-click on the Protocols folder for the SQL Server database instance and choose Properties from the pop-up menu.
- Set the Force Encryption value to Yes. This will require all database users have encrypted connections.
- In the Protocol Properties window, select the encryption tab.
- Select the appropriate certificate that was installed by your system dministrator.
- Click the OK button.
Tips:
- When you complete this process, the server will reject any requests for unencrypted communications. This feature will protect your database contents from eavesdropping while in transit between the client and server.
What You Need
- Microsoft SQL Server
- SQL Server Configuration Manager
