Transparent Archive Guide

Back Next

Microsoft SQL Server Connection Parameters

Define the following connection parameters for a Microsoft SQL Server database:

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 Instance Name: The instance name of the Microsoft SQL Server database.; If the Microsoft SQL Server database is configured to use dynamic port allocation, you can enter the Server Instance Name to identify the listener port. If you enter the instance name, you do not need to enter a Server Port number.
Server Port: TCP/IP listener port for the Microsoft SQL Server database. If you enter the Server Port number, you do not need to enter a Service Instance Name.
Optional Parameters: Additional parameters for the Informatica driver for Microsoft SQL Server.
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.