IBM Support

IT31729: "SQLDRIVERCONNECT TO [SERVER/INSTANCE] FAILED, ERR [[MICROSOFT][ODBC SQL SERVER DERIVER]" DURING SQL TEST OR BACKUP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running the SQL connection test, or running an SQL backup,
    these can fail with the following:
    INFO sqlvdiwrapper - SQLRoutine: connecting to server (Server\in
    stacne)
    DEBUG sqlvdiwrapper - connectingString [DRIVER={SQL Server};SERV
    ER=Server\instance;Trusted_Connection=Yes;]
    ERROR sqlvdiwrapper - Failed to execute SQL command, err [SQLRou
    tine: SQLDriverConnect to [Server\instance] failed, err[Microsof
    t][ODBC SQL Server Driver][DBMSLPCN]SSL Security error], ret(0)]
    

Local fix

  • Enable TLS 1.0 on the SQL Server machine(s).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus level 10.1.4 and 10.1.5            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in 10.1.5 patch1 and 10.1.6. Note that *
    * this is subject to change at the discretion of IBM           *
    ****************************************************************
    

Problem conclusion

  • Instead of using default version of ODBC driver, made changes to
    use the latest version of the ODBC driver that is available on
    the SQL server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31729

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A14

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-03

  • Closed date

    2020-02-13

  • Last modified date

    2020-02-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A14","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024