IBM Support

Enabling Force Encryption in Microsoft SQL Server causes IBM i2 iBase Intellishare to fail

Troubleshooting


Problem

When enabling Force encryption in Microsoft SQL Server, after starting up the IBM i2 iBase Intellishare server, an error is shown in the portal and users are unable to login and use the software.

Symptom

Unknown error: [HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound

Cause

After enabling Force Encryption in Microsoft SQL Server, the server is essentially set to reject any connections which are not encrypted. As the standard connection string for IBM i2 iBase IntelliShare is not set up to allow encryption, it must first be modified to resolve this issue.

Resolving The Problem

To resolve the issue, follow these steps

  1. Log on to the server where IBM i2 iBase IntelliShare is installed
  2. Stop the IBM i2 iBase intellishare instance from running
  3. Navigate to the following folder.
    • \jboss\server\intellishare\deploy\
  4. In this directory is a file called mssql-ds.xml. First, make a copy of this file and put it somewhere safe.
  5. Now open the original file and you should find some XML that contains 3 defined data sources.
  6. Add ";ssl=true;" to the end of each <connection-url> for each of your defined datasources, so that it looks something like the following
    • <connection-url>jdbc:jtds:sqlserver://nameOfBox/Name_Of_Database;user=yourUsername;password=yourPassword;ssl=true;</connection-url>
    • Obviously for the above you should leave the currently defined string alone apart from adding ";ssl=true;" to the end, as the one above is given only as an example
  7. Restart your IBM i2 iBase Intellishare Server
  8. Navigate to your IBM i2 iBase IntelliShare server and login, making sure everything works as before.
    • If you have issues, restore the copy of the file back to where it was before to restore the server to the way it was before.
[{"Product":{"code":"SSXVTH-1","label":"i2 Intelligence Analysis Platform"},"Business Unit":{"code":"BU008","label":"Security"},"Component":"i2 iBase IntelliShare","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
i2 Intelligence Analysis Platform

Software version:
8.9.1

Operating system(s):
Windows

Document number:
280711

Modified date:
19 February 2022

UID

swg21984306

Page Feedback