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