DevTest VSE issues in Linux Environment not connecting to Registry SQLSERVER with Integrated security

Document ID : KB000098176
Last Modified Date : 04/06/2018
Show Technical Document Details
Issue:
VSE server on Linux is not starting when pointing to a remote registry in a Windows box.  The Registry database is SQL Server with integrated security enabled. 
Environment:
All supported DevTest environment
Cause:
When Integrated security is enabled for SQL Server,  there is a limitation with jdbc driver on linux.  You would have to use jtds driver instead.
Resolution:
When trying to connect VSE which is on a Linux Servier to a Registry on Windows where Integrated security is enabled  for 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 VSE