Maximo fails to connect to SQL Server database during SSL Handshake

Troubleshooting

Problem

An error is reported when a connection is made to the SQL Server database when Maximo starts, or when running a Maximo script such as UpdateDB, ConfigDB or encryptproperties.

Symptom

If the failure occurs during Maximo startup, the following exception is seen:

BMXAA6538E - Failed to initialize MAXIMO business object services. psdi.util.MXSystemException: access#DBConnectFail at psdi.server.MXServer.checkMtEnabled(MXServer.java:6395) at psdi.server.MXServer.start(MXServer.java:3650) at psdi.servlet.MAXIMOStartupServlet.init(MAXIMOStartupServlet.java:92) at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:342) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168) at com.ibm.ws.webcontainer.servlet.ServletWrapper.loadOnStartupCheck(ServletWrapper.java:1376)

If the failure occurs during the execution of a Maximo script such as ConfigDB, the following exception is seen:

BMXAA6806I - Reading the properties file maximo.properties.

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish

a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

. Error: "SQL Server did not return a response. The connection has been closed.

ClientConnectionId:".

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerC

onnection.java:2397)

        at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1762)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLSer

verConnection.java:1977)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConne

ction.java:1628)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLS

erverConnection.java:1459)

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.6, 7.6.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.6, 7.6.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Maximo Asset Management

Software version:
7.6, 7.6.1

Operating system(s):
Windows

Document number:
1098915

Modified date:
15 June 2020

UID

ibm11098915

IBM Support

Tips