Configuring a Masking Connector to Work with an AD Account

To enable SQLserver DB access using AD account for Delphix Masking 

1. Do not attempt to use <DomainName>\<UserName> format
2. Ensure a regular local SQLserver user, eg. "delphixmasking" shows as SQLserver authentication under SSMS and successfully tests as Delphix connector 
3. Check the AD account permissions under SSMS
   1. will need to add access to the specific DB desired
   2. The default MSSQL jtds JDBC connector string needs to add the domain=AD (use your DomainName) parameter
   3. use the advanced connector to be able to pass this parameter; sample string looks like:  jdbc:jtds:sqlserver://10-43-100-101.ad.delphix...CUIT;domain=AD

Related Articles

External Links:

• https://serverfault.com/questions/457798/why-does-a-d-account-need-sql-server-login
• https://esha.zendesk.com/hc/en-us/articles/202977089-Granting-Access-to-Additional-Users-with-SQL-Server-Management-Studio-for-Genesis-Food-and-Food-Processor