View Source

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:

Comment the default CAST Storage Service entry in the web.xml
Uncomment the required Microsoft SQL Server entry in the web.xml
For a named instance, use the following entry on the JDBC database section (e.g. add the ;domain=AD_DOMAIN_NAME)

<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>

For an instance and port number, use the following entry on the JDBC database section (e.g. add the ;domain=AD_DOMAIN_NAME)

<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

Remove the value for the <param-value> tag on the JDBC user and the JDBC password sections
Enter the CAST Dashboard Service name on the JDBC Central database section
For example for a named instance:

<!-- 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