Most Popular
Recently Added
Recently Updated

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

Properties ID: 000032   Views: 1357   Updated: 5 years ago
Filed under: