IBM Support and do not have checks for MSSQL failover , jdbc url string incorrect

Technote (troubleshooting)


MSSQL2008 failover cannot be automatically setup using a variable in sandbox.cfg. Instead you have to manually hardcode it into and and run / setupfiles.cmd


In and you have to hard code the URL string to allow MSSQL2008 failover as shown below: :-

sqlserver://servername:port;databaseName=GIS51;failoverPartner=otherservername :-

<property name="driverClassName">
<property name="url">
<property name="username">

A variable should be defined in sandbox.cfg which populates MSSQL2008 failover the same as oracle already does.


No variable defined in sandbox.cfg and functionality not added to and to check for variable.

Resolving the problem

Apply patch 5.1.03 and use new variable MSSQL_JDBC_URL in sandbox.cfg to define the full jdbc url.

Historical Number


Document information

More support for: Sterling B2B Integrator

Software version: 5.1

Operating system(s): Platform Independent

Software edition: All Editions

Reference #: 1576027

Modified date: 05 March 2013