Using Windows Authentication to Connect to the EPIM Database

To set up the ability to log onto EPIM and EPX databases with the network domain account:

The EPIM and EPX databases are set with the network domain account as the database owner.
Copy the file:
```
ntlmauth.dll
```
from the appropriate architecture directory, from the attached zip:
```
jtdsjdbc-sso.zip
```
to your installation location:
```
<drive>:\Enterworks\JDK\JRE\bin
```
Remove the username and password from all database connection strings and update connection strings to use integrated security:
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. In the Enterworks.properties files:
  - <drive>:\Enterworks\EPX\bin\conf\Enterworks.properties
  - <drive>:\Enterworks\EnableServer\tomcat\webapps\webcm\WEB-INF\classes\Enterworks.properties
  - <drive>:\Enterworks\EnableServer\jbossController\standalone\configuration\conf\Enterworks.properties
  and for each worker:
```
<drive>:\Enterworks\EnableServer\jbossWorker<x>\standalone\configuration\conf\Enterworks.properties
```
  update:
  1. Remove the username and password.
  2. Update JDBC URLs for both EPIM and EPX.
4. For EnableWeb and Enable Utilities, in the following files:
```
<drive>:\Enterworks\EnableWeb\Web.config
<drive>:\Enterworks\Utilities\DAMReportUtility\DAMReportUtility.exe.config
<drive>:\Enterworks\Utilities\MonitorDamdrop\MonitorDamdrop.exe.config
<drive>:\Enterworks\Utilities\DAMReportUtility\DAMReportUtility.exe.config
<drive>:\Enterworks\Utilities\RegenerateDAMVariant\RegenerateDAMVariant.exe.config
```
  make the following updates:
  1. Update the connection string to remove the user name 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" />
```
Restart EnterWorks services.