Issue Description:
Is it possible to use Windows Authentication to authenticate against SQL Server hosting JasperServer repository database?
Resolution:
To have jasperServer use Windows Authentication to authenticate against SQL Server:
Download the jTDS driver
Copy the jTDS jar file to the app server's lib folder
Copy the ntlmauth.dll file found in the download to the <jre-home>/bin folder
Set up the app server to run as the same user used to do Windows authentication
Use the below JNDI block in your jasperserver-proMETA-INFcontext.xml file
<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username=<yourNetworkAccount> password=<yourNetworkAccountPassword> driverClassName="net.sourceforge.jtds.jdbc.Driver" accessToUnderlyingConnectionAllowed = "true" validationQuery="SELECT 1" testOnBorrow="true" url="jdbc:jtds:sqlserver://<yourServer>:<yourPort>/jasperserver;useNTLMv2=TRUE;domain=<yourDomain>" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory"/>
Restart JasperServer after making the above changes
Recommended Comments