Skip to main content
Delphix

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

 

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>

Related Articles

External Documentation: