Authenticate with Windows Authentication (using JDBC Resource) in TIBCO BW 6

Hi,

In this post we will learn how to use Windows Authentication in TIBCO BW 6.

Follow those steps:

1. Download Microsoft JDBC drivers for sql server from:

https://www.microsoft.com/en-us/download/details.aspx?id=11774

2. Extract the contents of the download driver and copy “sqljdbc_auth.dll” (inside <installation directory>\sqljdbc_<version>\<language>\auth\) to \Windows\System32 folder.

3. In your JDBC Connection item: choose the appropriate sql driver, and use the following connection string (with integrationSecurity=true):
jdbc:sqlserver://MyServerName;databaseName=MyDBName;integratedSecurity=true;

You still need to provide a dummy user name and password. BW6 does not allow an empty user name and password.