SQL Server with Windows Authentication

Use Case

How to a MS SQL Server node that uses Windows authentication.

Solution

1. Add the ntlmauth.dll to your SymmetricDS lib folder. You can obtain this from the jtds distribution based on the version your using.

   http://sourceforge.net/projects/jtds/files/jtds/
   

2. Append the following to your JDBC url.

   useNTLMv2=true
   domain=yourdomain
   

   Resulting JDBC url should look like the following:

   jdbc:jtds:sqlserver://{HOST}/{DATABSE};useCursors=true;bufferMaxMemory=10240;
   lobBuffer=5242880;socketTimeout=300;appName=symds;useNTLMv2=true;domain={YOUR DOMAIN}
   

3. Leave the user and password fields blank