Page tree
Skip to end of metadata
Go to start of metadata

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