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:

Edit the shared configuration properties settings:

In the sharedConfiguration.properties files, comment out the username and password keys.

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;

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;
```

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:

Remove the username and password.
Update JDBC URLs for both EPIM and EPX.

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:

Update the connection string to remove the user name and password.

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.