Skip to main content
Delphix

Use a domain account in Masking connector configuration for Microsoft SQL (MSSQL)

Issue

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

Following the steps below, it's possible to use a domain account:

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

 

Additional Information

Delphix uses jTDS, the open source JDBC driver for MSSQL databases, therefore it is possible to customize the connection string as preferred.

External Links 

jTDS homepage: http://jtds.sourceforge.net/index.html

  • Was this article helpful?