VSE on Linux not connecting to Registry SQL SERVER with Integrated security

Document ID : KB000098176
Last Modified Date : 03/07/2018
Show Technical Document Details
Issue:
VSE service on Linux is not starting when pointing to a remote Registry in a Windows box.
The Registry database is Microsoft SQL Server with integrated security enabled.
When we try to start the VSE service, it runs for about 2 minutes and throws the below error:
java.lang.RuntimeException: Connection to the registry database cannot be established. Please make sure the database is running and the credential used to connect to database is valid. 
at com.itko.lisa.utils.JpaUtil$2.run(JpaUtil.java:1678) 
at java.lang.Thread.run(Thread.java:745) 
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException 
Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database! 
Error Code: 0 
Environment:
All supported DevTest environment
Cause:
When Integrated security is enabled for SQL Server,  there is a limitation with jdbc driver on linux. We would have to use jtds driver instead.
Resolution:
When trying to connect VSE which is on a Linux Server to a Registry on Windows where Integrated security is enabled for MS SQL Server Database, Registry should use the SQLServer JDBC Driver and VSE on Linux can use the JTDS driver.

Steps to follow: 
1. On the Windows machine  where Registry is running  in site.properties file have the SQL DB configuration with Integrated Security enabled ,

lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

lisadb.pool.common.url=jdbc:sqlserver://ABC4W7A:1433;databaseName=REGDB;integratedSecurity=true

lisadb.pool.common.user=TNT-A01\user

lisadb.pool.common.password=<password>

2. In the linux server where VSE is running, copy the jtds driver to DevTest-Home/lib/shared folder 
Driver File Name: jtds-1.3.1.jar 
add the properties in the same format as listed here, just modify DB name, domain and user/pass... 

lisadb.internal.enabled=false 
lisadb.pool.common.driverClass=net.sourceforge.jtds.jdbc.Driver 
lisadb.pool.common.url=jdbc:jtds:sqlserver://10.162.27.26:1433;instance=MSSQLSERVER;databaseName=devtest;domain=ABC03N220900;user=myUser;password=ABC@123; 
lisadb.pool.common.user=ABC03N220900\myUser 
lisadb.pool.common.password=5e298cc850c


Restart the VSE service.