IBM Support

Test connection button in WebSphere Application Server fails when trying to connect to Microsoft SQL Server datasource (XA)

Troubleshooting


Problem

The test connection button fails to establish a connection to Microsoft® SQL Server with a "Could not find stored procedure 'master..xp_jdbc_open' " error when connecting from WebSphere® Application Server.

Symptom

[1/31/11 13:39:35:799 EST] 0000002d DSConfigurati W DSRA8201W: DataSource Configuration: DSRA8040I: Failed to connect to the DataSource. Encountered java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Could not find stored procedure 'master..xp_jdbc_open2'.DSRA0010E: SQL State = HY000, Error Code = 2,812.

Cause

The following exception occurs due to missing components from the Microsoft SQL Server database:

SQLState(HY000) vendor code(2812)
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Could not
find stored procedure 'master..xp_jdbc_open'.
at com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown
Source)
at
com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

Resolving The Problem


To resolve this issue, install the Stored Procedures for JTA onto the Microsoft SQL Server installation. The installation instruction are available from DataDirect here:

JTA Support: Installing Stored Procedures

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5.5;8.0;7.0","Edition":"Edition Independent","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21168355

Page Feedback