Ephesoft version: 3.0.x to 4.0.2.x

 

Ephesoft will work with windows authentication for it’s primary databases. Fuzzydb Windows Authentication is also supported.

Download:

http://www.ephesoft.com/Ephesoft_Product/Wiki_links/MSSQL_windowsAuthentication.zip

Installation Steps:

Note: Please take back up of the all the files before modifying or deleting them.

1. Stop the Ephesoft server.
2. Rename the attachment to .zip from .abc extension and extract the zip (MS SQL Server Windows Authentication fix.zip) into some temporary location.
3. Copy extracted ntlmauth.dll file to <Ephesoft Installation directory>\Application\native\ directory. Use the 32 or 64 bit version depending on your sql version.

HINT: sql query to determine 32 or 64 bit version:
SELECT SERVERPROPERTY(‘Edition’)

4. Take backup and then edit below properties in dcma-db.properties file under <Ephesoft Installation directory>\Application\WEB-INF\classes\META-INF\dcma-data-access\ directory.

dataSource.driverClassName=net.sourceforge.jtds.jdbc.Driver
dataSource.dialect=com.ephesoft.dcma.da.common.EphesoftSQLServerDialect
dataSource.url=jdbc\:jtds\:sqlserver\://${dataSource.serverName};databaseName\=${dataSource.databaseName};domain\=${dataSource.domain}

5. Comment out below two property from dcma-db.properties file by prefixing the line with # as shown below. No need to give any user name and password here.

#dataSource.password=password
#dataSource.username=sa

6. Create a new property dataSource.domain in dcma-db.properties file as shown below.

dataSource.domain=<domain name>

7. To get domain name of a machine. Open a command prompt and type “set” and press enter. It will list out some property. Find ‘USERDOMAIN’ property in that list.
8. Take backup and then delete dcma-dao.xml file from <Ephesoft Installation directory>\Application\WEB-INF\classes\META-INF\dcma-data-access\.
9. Copy the extracted dcma-dao.xml to Ephesoft Installation directory>\Application\WEB-INF\classes\META-INF\dcma-data-access\.

If you prefer to manually make changes to your dcma-dao.xml file, you will need to comment out the following:

 

<!– <bean id=”passwordDecryptor” class=”com.ephesoft.dcma.encryption.core.PasswordDecryptor”>

<property name=”encryptedString” value=”${dataSource.password}”></property>

</bean> –>

<!– <prop key=”user”>${dataSource.username}</prop>

<prop key=”password”>#{passwordDecryptor.decryptedString}</prop> –>

 

10. Save and close the file. Start the Ephesoft Server.

Windows Authentication: Ephesoft Reporting

  1. Stop the Ephesoft server or service.
  2. Take backup and then edit the etl-variables.properties file under <Ephesoft Installation directory>\Application\WEB-INF\classes\META-INF\dcma-reporting directory as mentioned below.
  3. Uncomment the reporting.domain and reporting.url(the one that contains a domain parameter ) property as shown below-

reporting.domain=<domain>

reporting.url=jdbc\:jtds\:sqlserver\://$dcmareport{reporting.hostname};\:$dcmareport{reporting.port};databaseName\=$dcmareport{reporting.dbname};domain\=$dcmareport{reporting.domain};sendStringParametersAsUnicode\=false;prepareSQL\=3 

4. comment the reporting.url (one without the domain parameter) property as shown below

#reporting.url=jdbc\:jtds\:sqlserver\://$dcmareport{reporting.hostname};\:$dcmareport{reporting.port};databaseName\=$dcmareport{reporting.dbname};sendStringParametersAsUnicode\=false;prepareSQL\=3 

5. Update the following properties and set their values blank:

reporting.username=

reporting.password=

ephesoft.username=

ephesoft.password=

6. Start the Ephesoft Server or service

 

 

<Back| 4.0.0.0 Release Documentation

Was this article helpful to you?

Engineering

Comments are closed.