How to enableSQL Server Windows Authentication for MDM.

How to enableSQL Server Windows Authentication for MDM.

book

Article ID: KB0093236

calendar_today

Updated On:

Products Versions
TIBCO MDM -
Not Applicable -

Description

Description:
Enabling  SQL Server Windows Authentication with MDM.

Issue/Introduction

How to enableSQL Server Windows Authentication for MDM.

Resolution

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.