Skip to main content
Delphix

Configuring Masking Connector for Microsoft SQL (MSSQL) (KBA1214)

 

 

Note

Note:

This article is no longer current. The best solution is to use the properties of the Basic Connector. You can find more information about the Basic Connector in the following article:  Configuring a Masking Connector to Work with an AD Account (KBA1820).

 

 

Troubleshooting Masking Connector Configuration

The masking connector GUI interface does not currently allow special characters in most of the fields, including the Login ID, therefore, it is not possible to use a windows domain account for a Microsoft SQL (MSSQL) connector.  

Resolution 

Follow the steps to use a domain account:

  1. Switch the SQL server connector from Basic to Advanced.
  2. Fill all the information and username as required, without the domain.
  3. In JDBC URL, use the following syntax as an example: 
    jdbc:jtds:sqlserver://<serverName>:<portNumber>/<dbName>;useNTLMv2=true;domain=<domainName>

EditConnector_MSSQL_DB.png

Related Articles

External Documentation: