Using Windows Authentication to Connect to the EPIM and EPX Databases - Precisely_EnterWorks - EnterWorks - 11.0

ntlmauth.dll

from the appropriate architecture directory, from the attached zip:

jtdsjdbc-sso.zip

to your installation location:

            <drive>:\Enterworks\JDK\JRE\bin

1. Edit the shared configuration properties settings:
   1. In the sharedConfiguration.properties files, comment out the username and password keys.
   2. To the JDBC URL, add:

      instance=USENTLMV2=true;

      as shown in the example below:

      #epim.connection.username=ewsys
      #epim.connection.password=uMb/Xk0BwIA=
      epim.connection.url=jdbc:jtds:sqlserver://DBServer:1433;
      databasename=EPIM;
      instance=USENTLMV2=true;

2. In the file:

   <drive>:\EPX\bin\esjdbc.properties

   update the EPX database settings:
   1. Comment out the username and password keys.
   2. Add to the JDBC URL:

      instance=USENTLMV2=true;

3. Edit each of the Enterworks.properties files:

   On the server hosting this Service	Location
   EnableServerTomcat	<drive>:\Enterworks\EnableServer\tomcat\enterworks-props\Enterworks.properties
   EnableServerWildflyController	<drive>:\Enterworks\EnableServer\jbossController\standalone\configuration\conf \Enterworks.properties
   EnableServerWildflyWorker<n>	<drive>:\Enterworks\EnableServer\jbossWorkerN\standalone\configuration\conf\Enterworks.properties
   EPX	<drive>:\Enterworks\EPX\bin\conf\Enterworks.properties

   Make the following changes:
   1. Remove the username and password.
   2. Update JDBC URLs for both EPIM and EPX.
4. If the following file exists, edit it:

   <drive>:\Enterworks\EnableWeb\Web.config

   Make the following updates:
   1. Update the connection string to remove the username and password.
   2. Add:

      Trusted_Connection=True;

      to the URL. For example:

      <add name="EPIMConnectionString" connectionString="Data Source=
      DBServer;Initial Catalog=EPIM;Persist Security
      Info=True;Trusted_Connection=True;MultipleActiveResultSets=True"
      providerName="System.Data.SqlClient" />