Enable SSL Encryption for an MSSQL Network Transport Layer

Prerequisites and Preparations

1. Create a Test Table

USE [TestDb]
GO
IF OBJECT_ID('dbo.CustomerInfo', 'U') IS NOT NULL
DROP TABLE dbo.CustomerInfo
CREATE TABLE dbo.CustomerInfo
(
CustomerId INT IDENTITY(10000,1) NOT NULL PRIMARY KEY,
CustomerName VARCHAR(100) NOT NULL,
CustomerPhone CHAR(11) NOT NULL
);
-- Init Table
INSERT INTO dbo.CustomerInfo
VALUES ('CustomerA','13402872514')
,('CustomerB','13880674722')
,('CustomerC','13487759293')
GO

2. Start MNM and Add New Capture

3. Conduct a Connection Query Test

USE [TestDb]
GO
SELECT * FROM dbo.CustomerInfo WITH(NOLOCK)

4. Check Events in MNM

5. Check the Connection Status in the Dynamic Vew

Enable an SSL Certificate

1. Request a Certificate

2. Force All Connections to Use SSL

3. Encrypt Specific Client Connections

4. Enable Encrypt Connection in SSMS

Summary

Original Source

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store