Installation and Upgrade Guide

9.9
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Upgrade the Dynamic Data Masking for Microsoft SQL Server Service

You must manually upgrade the Dynamic Data Masking for Microsoft SQL Server service from version 9.5.1 or earlier.

Perform the following steps for each Microsoft SQL Server database defined in the Management Console tree:

Open the Dynamic Data Masking 9.5.2 or later Management Console.

Select a Microsoft SQL Server database node in the Management Console tree and click

Tree

Edit

The

Edit

window appears.

Note the following Microsoft SQL Server database parameters in the

Edit

window:

DDM Database Name

SQL Server Databases

DDM Port

Default Rule Set

Click

to close the window.

Select the Dynamic Data Masking Server in the Management Console tree and click

Tree

Add DDM Services

The

Add DDM Services

window appears.

Select

DDM for SQL Server

and click

to close the window.

Select the Dynamic Data Masking for Microsoft SQL Server service in the Management Console tree and click

Tree

Edit

The

Edit

window appears.

Click

Add Port

and enter the port number from the Microsoft SQL Server database node.

Click

to close the

Edit

window.

Select the Dynamic Data Masking for Microsoft SQL Server service in the Management Console tree and click

Tree

Connection Rules

The

Rule Editor

window appears.

In the

Rule Editor

window, click

Action

Append Rule

The

Append Rule

window appears.

Specify the following properties in the

Append Rule

window:

Property	Value
Rule Name	<database name>DB
Matcher	Incoming DDM Listener Port
Incoming Port	Enter the port number from the Microsoft SQL Server database node.
Rule Action	Switch to Database
Database	Enter the DDM Database Name from the Microsoft SQL Server database node.
Processing Action	Continue

Click

to close the

Append Rule

window.

In the

Rule Editor

window, click

Action

Append Rule

The

Append Rule

window appears.

Specify the following properties in the

Append Rule

window:

Property	Value
Rule Name	apply<rule set name>
Matcher	All Incoming Connections
Rule Action	Use Rule Set
Rule Set Name	Enter the Rule Set Name specified in the default rule set parameter from the Microsoft SQL Server database node.
Processing Action	Stop if Applied