Products | Versions |
---|---|
TIBCO MDM | - |
Not Applicable | - |
1). Enable integrated Security by changing the connection URL in the JBoss standalone.xml datasource.
<connection-url>jdbc:sqlserver://localhost:1433;databaseName=mdmdb;integratedSecurity=true</connection-url>
2). Remove other security parameters from JBoss standalone.xml datasource. i.e. user and password.
3). Download and add sqljdbc_auth.dll in the library path. For Windows, add it in JBOSS standalone.xml in system-properties, such as, <property name="java.library.path" value="C:\builder\sqljdbc_4.0\enu\auth\x64"/> , or add it to the JVM argument -Djava.library.path="C:\builder\sqljdbc_4.0\enu\auth\x64"
4). Based on how Windows and SQLServer is configured, an additionall DLL may need to be added in the PATH and Windows/system32 . In most cases, the above three steps are sufficient.
5). Download the SQLServer JDBC driver from Microsoft and you will find the required DLL.