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