Friday, July 7, 2017

BIRT Report Windows Authentication Tomcat

On TomCat where BIRT is deployed server
  • ·         Copy the sqljdbc_auth.dll in Java home location i.e. C:\Java\jre7\bin\
  • ·         Copy the sqljdbc4.jar[This jar is different for Windows Authentication] in TomCat’s lib directory C:\Tomcat_WHERE_BIRT_IS\lib\
  • ·         Edit manually the rpt file and change the config
<property name="odaURL">jdbc:sqlserver://DBSERVER:1433;Database=dbName;integratedSecurity=true;</property>

Total Pageviews