Resolution:
Steps for connecting to SQL Server using SQL Native Driver with Windows Authentication.

1). Download the SQL Drivers.
2). Extract the contents of the download driver and copy “sqljdbc_auth.dll” inside <installation directory>\sqljdbc_<version>\<language>\auth\  to the  \Windows\System32  folder.
3). Add sqljdbc4.jar  to the TIBCO Installation\tpcl\<version>\jdbc .
4). Use the URL with integratedSecurity=true;
jdbc:sqlserver://DBANC01:1433;databaseName=PioneerAVM;integratedSecurity=true;