Opt1:  using MS JDBC Driver com.microsoft.sqlserver.jdbc.SQLServerDriver

1. Get the latest version of Microsoft SQL Server JDBC Driver from microsoft.com site. Unzip it. Then:
  • copy sqljdbc4.jar to <tibco_home>\tpcl\5.6\jdbc
  • Note that: The sqljdbc.jar sometimes cannot be used as the JRE environment version may not supporting it.
  • copy \auth\x86\sqljdbc_auth.dll to C:\WINDOWS\SysWOW64 (or to C:\WINDOWS\System32 on 32bit system) and to <tibco_home>\tra\5.6\bin
2. Configure your BW-application to use appropriate driver and connection string:
     JDBC_Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

     URL: jdbc:sqlserver://<server_name>;instanceName=<instance>;databaseName=<database>;integratedSecurity=true;

 e.g.
jdbc:sqlserver://stetibsql01:1433;databaseName=Tib_PROD_REF;integratedSecurity=true;


Test===================================================================

Opt2:  using MS JDBC Driver tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver


1. Configure your BW-application to use appropriate driver and connection string:
    JDBC_Driver: tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver
     URL: jdbc:tibcosoftwareinc:sqlserver://<server_name>;instanceName=<instance>;databaseName=<database>;authenticationMethod=type2;loadLibraryPath=[tpcl_jdbc_dir];

e.g.
jdbc:tibcosoftwareinc:sqlserver://stetibsql01:1433;databaseName=Tib_PROD_REF;authenticationMethod=type2;loadLibraryPath=C:\tibco\classic\tpcl\5.8\jdbc;StringInputParameterType=varchar

Test