Stored Procedure Accelerator Guide for Microsoft SQL Server

Back Next

Step 3. Create a Database Connection

Add the Dynamic Data Masking service for Microsoft SQL Server in the Management Console and connect to the database.

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

OK.

The DDM for SQL Server node appears in the Management Console tree.

Select the Management Console tree root node and click

Tree

Add Database

The

Add Database

window appears.

Select the Microsoft SQL Server database type and configure the database connection parameters.

The following table describes the connection parameters:

Parameters	Description
DDM Database Name	Name for the database in the Management Console tree.
Server Address	Server host name or TCP/IP address for the Microsoft SQL Server database. Verify that there is no firewall that prohibits the Dynamic Data Masking Server from connecting to the database server and port number.
Server Port	TCP/IP listener port for the Microsoft SQL Server database.
Optional Parameters	Additional parameters for the Informatica driver for Microsoft SQL Server.
Database Name	Optional name of a Microsoft SQL Server database. Used for manual upgrade of Dynamic Data Masking for Microsoft SQL Server service.
Rule Set	Optional rule set you can define for a specific database in addition to the Default Rule Set. Used for manual upgrade of Dynamic Data Masking for Microsoft SQL Server service.
DDM Port	Dynamic Data Masking listener port. Use DDM Port for a manual upgrade of the Dynamic Data Masking for Microsoft SQL Server service.
Default Rule Set	Use for manual upgrade of Dynamic Data Masking for Microsoft SQL Server service. Leave blank to create a Microsoft SQL Server database connection.
DBA Username	User name for the database user account to log in to the Microsoft SQL Server database.
DBA Password	Password for the database user.