IBM Support

BMXAA6421E Could not establish a secure connection to SQL Server by using SSL

Troubleshooting


Problem

After updating a WebSphere fixpack, starting up Maximo, you get an error 500 of on the login screen and the following error in systemOut.log: BMXAA6421E - The system could not connect to the JDBC source.

Symptom

[ERROR] [] [] BMXAA6421E - The system could not connect to the JDBC source: jdbc:sqlserver://;serverName=localhostexample; databaseName=MaxDB;portNumber=1433;integratedSecurity=false;The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Only SSLv3 was enabled while com.ibm.jsse2.disableSSLv3 is set to true".

Resolving The Problem

Shut down Websphere.

Install the WebSphere hotfix to disable SSLv3 as per this link https://www.ibm.com/support/docview.wss?uid=swg21687173

Download the Microsoft SQLJDBC driver hotfix from https://support.microsoft.com/en-us/help/982512/.

Since the filename sqljdbc.jar may be hard-coded in other code, rename the old sqljdbc.jar to sqljdbc.jar.old.

Copy the sqljdbc4.jar into Maximo admin workstation (folder: .\maximo\applications\maximo\lib)

Rename sqljdbc4.jar, then rename that to sqljdbc.jar.

Rebuild Maximo EAR, deploy and restart the Maximo application server.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21694943