Skip to main content
Pentaho Documentation

Windows Domains Won't Authenticate When Using the JTDS Driver

If you are using a JTDS JDBC driver and you want to use a Windows domain user to authenticate to a Microsoft SQL Server, be aware that the Windows syntax will not work for specifying the domain and user. In the URL field, the domain must be appended to the end of the URL with a semicolon:

jdbc:jtds:sqlserver://svn-devel.example.com:1533/reportsInProgress;domain=testdomain