KB Articles

KB Article # 9263

Topic/Category: MSSQL Database

Ephesoft Version: 4030+

Issue: Windows Authentication with Ephesoft/Report MSSQL Database

Analysis:

Ephesoft 4030+ supports MSSQL windows authentication

Solution:

1.  Modify the jdbcUrl property in the Ephesoft\JavaAppServer\conf\server.xml file for the ephesoft and report database and append the domain property as shown in the sample URL below.

 

jdbcUrl="jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=false;prepareSQL=3;domain=<domain_name> "

replace the <domain_name> with the appropriate domain for windows authentication.

 

2. Set the dataSource.user and datasource.password to empty values as shown below:

dataSource.user=””

datasource.password =””

 

 

< Back|KB Main Page | Next KB Article >

Was this article helpful to you?

Walter Lee

Comments are closed.