Delphix Products

On the masking engine, MSSQL Database Connector with a Database local user and password works fine. Can authentication be made with an AD based Windows Authentication? If yes, please provide details on how that can be achieved.

On the masking engine, MSSQL Database Connector with a Database local user and password works fine. Can authentication be made with an AD based Windows Authentication? If yes, please provide details on how that can be achieved.

please look into below KB
https://support.delphix.com/Continuous_Compliance_Engine_(formerly_Masking_Engine)/Configuring_a_Masking_Connector_to_Work_with_an_AD_Account_(KBA1820)

On the masking engine, MSSQL Database Connector with a Database local user and password works fine. Can authentication be made with an AD based Windows Authentication? If yes, please provide details on how that can be achieved.

Hi Vijayender,

Thanks for your reply.  This KB is also an option putting those parameters in a properties file.  You can also list it in the JDBC URL as I provided below.  Were you able to test it?

jdbc:sqlserver://<IP>:<Port>;databaseName=<dbName>;useNTLMv2=true;authenticationScheme=NTLM;integratedSecurity=true;user=<USER+AD>;

ROBΞRT HΞNNING Principal Solutions Engineer (215) 764-0815 robert.henning@delphix.com www.delphix.com Greater Washington, DC

please look into below KB
https://support.delphix.com/Continuous_Compliance_Engine_(formerly_Masking_Engine)/Configuring_a_Masking_Connector_to_Work_with_an_AD_Account_(KBA1820)

On the masking engine, MSSQL Database Connector with a Database local user and password works fine. Can authentication be made with an AD based Windows Authentication? If yes, please provide details on how that can be achieved.

Thank you for your response. I am waiting for DBA to grant permissions to a database to give this option a try. One follow up question to Robert's response. Even though the User Name is mentioned in the connection string, should I also mention the same user name and its corresponding password in the respective connector UI fields?

Hi Vijayender,

Thanks for your reply.  This KB is also an option putting those parameters in a properties file.  You can also list it in the JDBC URL as I provided below.  Were you able to test it?

jdbc:sqlserver://<IP>:<Port>;databaseName=<dbName>;useNTLMv2=true;authenticationScheme=NTLM;integratedSecurity=true;user=<USER+AD>;

ROBΞRT HΞNNING Principal Solutions Engineer (215) 764-0815 robert.henning@delphix.com www.delphix.com Greater Washington, DC

please look into below KB
https://support.delphix.com/Continuous_Compliance_Engine_(formerly_Masking_Engine)/Configuring_a_Masking_Connector_to_Work_with_an_AD_Account_(KBA1820)

On the masking engine, MSSQL Database Connector with a Database local user and password works fine. Can authentication be made with an AD based Windows Authentication? If yes, please provide details on how that can be achieved.

Hi Vijayender,

Thanks for your reply.  This KB is also an option putting those parameters in a properties file.  You can also list it in the JDBC URL as I provided below.  Were you able to test it?

jdbc:sqlserver://<IP>:<Port>;databaseName=<dbName>;useNTLMv2=true;authenticationScheme=NTLM;integratedSecurity=true;user=<USER+AD>;

ROBΞRT HΞNNING Principal Solutions Engineer (215) 764-0815 robert.henning@delphix.com www.delphix.com Greater Washington, DC

please look into below KB
https://support.delphix.com/Continuous_Compliance_Engine_(formerly_Masking_Engine)/Configuring_a_Masking_Connector_to_Work_with_an_AD_Account_(KBA1820)

On the masking engine, MSSQL Database Connector with a Database local user and password works fine. Can authentication be made with an AD based Windows Authentication? If yes, please provide details on how that can be achieved.