# IIQ Database Encryption

**URL:** <https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339>\
**Category:** IIQ Discussion and Questions\
**Tags:** identityiq\
**Created:** [June 12, 2026, 2:06am UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339 "2026-06-12T02:06:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![MRP4ND4](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@MRP4ND4](https://developer.sailpoint.com/discuss/u/MRP4ND4)\
**Post date:** [June 12, 2026, 2:06am UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339/1 "2026-06-12T02:06:48Z")

</div>

## Which IIQ version are you inquiring about?

_8.4p2 - On Windows with Apache Tomcat (SSB)_

## Share all details about your problem, including any error messages you may have received.

Hi everyone, I’m reaching out because I have an effort to encrypt the traffic between IIQ and the database’s that IIQ uses. We are on 8.4p2 and therefore we have 3 databases that we use. I have successfully encrypted the traffic on our DEV and QA environment but when I made the same change in our production environment the database administrators are showing that the traffic isn’t encrypted.

I’m not quite sure what i’m doing wrong in the production environment, why it wouldn’t show encrypted but the lower environments do.

I was hoping I could get some insights from others who’ve maybe done this before.

Here are my JDBC connection strings in iiq.properties:

```xml
dataSource.url=jdbc:sqlserver://piiqsql02:1433;databaseName=identityiq;encrypt=true;trustServerCertificate=false;

dataSourceAccessHistory.url=jdbc:sqlserver://piiqsql02:1433;databaseName=identityiqah;encrypt=true;trustServerCertificate=false;

pluginsDataSource.url=jdbc:sqlserver://piiqsql02:1433;databaseName=identityiqPlugin;encrypt=true;trustServerCertificate=false;

```

Steps I’ve taken so far:

1. The certificate has been installed on the server by the DBA’s / Sys Admins.
2. I’ve updated the iiq.properties file to have the above connection strings for each database.
3. Merged changes from my feat branch into my master
4. Ran Build Deploy
5. I rebooted Apache (cleared cache)
6. I Rebooted SailPoint IQ Service
7. I Rebooted the entire Server Host

I’m not sure if I missed some steps or something else maybe overridding the setting… Any help would be greatly appreciated!

> **[Integrating SailPoint with Microsoft SQL Server](https://documentation.sailpoint.com/connectors/identityiq/microsoft/sql_server/help/integrating_ms_sql_server/introduction.html)**
>
> SailPoint Connectors Documentation

---

<div class="post-metadata">

**Author:** ![naveenkumar3](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/naveenkumar3/32/39339_2.png) [@naveenkumar3](https://developer.sailpoint.com/discuss/u/naveenkumar3)\
**Post date:** [June 12, 2026, 2:37am UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339/2 "2026-06-12T02:37:39Z")

</div>

The Most likely cause: Stale SSB build — your edited `iiq.properties` was never packaged into the deployed WAR.

The fix could be is to rebuild the SSB artifact incorporating your `iiq.properties` changes, redeploy the WAR to Tomcat, then restart. Don’t just edit the file on disk and restart — in SSB, `iiq.properties` is a build-time artifact.

---

<div class="post-metadata">

**Author:** ![MRP4ND4](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@MRP4ND4](https://developer.sailpoint.com/discuss/u/MRP4ND4)\
**Post date:** [June 12, 2026, 1:46pm UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339/3 "2026-06-12T13:46:45Z")

</div>

I did do a rebuild through my deployment process. I usually first change the code via a feat branch, then merge into our master branch then do a build deploy which does the rebuild of our .war

---

<div class="post-metadata">

**Author:** ![naveenkumar3](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/naveenkumar3/32/39339_2.png) [@naveenkumar3](https://developer.sailpoint.com/discuss/u/naveenkumar3)\
**Post date:** [June 12, 2026, 3:12pm UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339/4 "2026-06-12T15:12:49Z")

</div>

In that case the issue could be The JVM truststore on prod doesn’t have the SQL Server certificate.

You have `trustServerCertificate=false`, which means the JDBC driver must validate the cert against the JVM truststore. If the cert isn’t there, some driver versions silently fall back to unencrypted rather than throwing an error.

Import the SQL Server cert into the JVM truststore on the prod host, and then restart tomcat.

---

<div class="post-metadata">

**Author:** ![neel193](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/neel193/32/34038_2.png) [@neel193](https://developer.sailpoint.com/discuss/u/neel193)\
**Post date:** [June 17, 2026, 3:43pm UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339/5 "2026-06-17T15:43:25Z")

</div>

@MRP4ND4 There could be multiple reasons for the issue:

- With trustServerCertificate=false, the JDBC driver performs full certificate validation. The SQL Server’s TLS certificate (or its CA chain) must be imported into the Java truststore (cacerts) on the IIQ application server.
- With trustServerCertificate=false, the certificate’s Common Name (CN) or Subject Alternative Name (SAN) must match the hostname used in the JDBC URL.
- Even though the client requests encryption, the SQL Server must also be properly configured to allow the server-side TLS.
- After making changes, ensure all existing connection pool connections are flushed. A full Tomcat restart (not just cache clear) should handle this, but verify no load balancer is routing to a stale instance.

Please review them and let us know if it works or not.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [August 16, 2026, 3:44pm UTC](https://developer.sailpoint.com/discuss/t/iiq-database-encryption/212339/6 "2026-08-16T15:44:08Z")

</div>

Closed on August 16, 2026, 3:44pm UTC

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
