This page is no longer maintained and may contain obsolete information.

If you would like to use a Windows Active Directory (AD) domain user to authenticate to a Microsoft SQL Server (instead of using a Microsoft SQL Server database user) then you should proceed as follows:


<context-param>
    <param-name>jdbc.database</param-name>
    <param-value>//192.168.20.10;instance=MY_SQL_SERVER;domain=AD_DOMAIN_NAME</param-value>
    <description>JDBC database</description>
</context-param>



<context-param>
    <param-name>jdbc.database</param-name>
    <param-value>//192.168.20.10:1433;domain=AD_DOMAIN_NAME</param-value>
    <description>JDBC database</description>
</context-param



<!-- Template for Microsoft SQL Server (with Instance Name) -->
    <context-param>
        <param-name>jdbc.driver</param-name>
        <param-value>net.sourceforge.jtds.jdbc.Driver</param-value>
        <description>JDBC driver</description>
    </context-param>
    <context-param>
        <param-name>jdbc.subprotocol</param-name>
        <param-value>jtds:sqlserver</param-value>
        <description>JDBC sub protocol</description>
    </context-param>
    <context-param>
        <param-name>jdbc.database</param-name>
        <param-value>//192.168.20.10;instance=MY_SQL_SERVER;domain=AD_DOMAIN_NAME</param-value>
        <description>JDBC database</description>
    </context-param>
    <context-param>
        <param-name>jdbc.user</param-name>
        <param-value></param-value>
        <description>JDBC user</description>
    </context-param>
    <context-param>
        <param-name>jdbc.password</param-name>
        <param-value></param-value>
        <description>JDBC password</description>
    </context-param>
    <context-param>
        <param-name>jdbc.schema</param-name>
        <param-value>CENTRAL_NAME</param-value>
        <description>JDBC Central database</description>
    </context-param>


  • Following any changes you make, save the web.xml file and then restart your J2EE compliant application server so that the changes are taken into account.
  • Please refer to the jTDS documentation for more information about URL formats: http://jtds.sourceforge.net/faq.html#urlFormat