CAST AIP 8.3.x Documentation
Page tree
Skip to end of metadata
Go to start of metadata

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
  • No labels