IT11894: DATA PROTECTION FOR SQL DATABASE COULD NOT CONNECT TO SQL SERVER WITH MESSAGE "THE TARGET PRINCIPAL NAME IS INCORRECT."

APAR status

• Closed as program error.

Error description

• When using the Tivoli Storage Manager for Databases: Data
  Protection for Microsoft SQL Server Get-DpSqlComponent Power
  Shell  cmdlet, the process may terminate with the following
  messages:
  
  ACO5424E Could not connect to SQL server; SQL server returned:
  Failed to connect to server 2008SQL-TEST,1433. A connection was
  successfully established with the server, but then an error
  occurred during the login process. (provider: SSL Provider,
  error: 0 - The target principal name is incorrect.) The target
  principal name is incorrect (HRESULT:0x80131501)
  At Get-DpSqlComponent -Private -Name * -ConfigFile "C:\Program
  Files\Tivoli\tsm\TDPSql\tdpsql.cfg" -CompatibilityInfo
  -SqlServer "2008SQL-TEST,1433" -SqlAuthentication INTegrated
  InvalidResult: (Capability.Impl....Sql.SqlContext:SqlContext)
  [Get-DpSqlComponent], Exception
  1900,IBM.Tivoli.TSM.Cmdlets.SQL.GetDpSqlComponent
  
  
  
  Customer/L2 Diagnostics (if applicable):
  In a Data Protection for SQL trace and Windows Event log , the
  following messages may be witnessed:
  09/16/2015 10:19:23.565 [004900] [4272] : SqlApi.cpp
  (6286): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->LoginSecure(false)
  09/16/2015 10:19:23.566 [004900] [4272] : SqlApi.cpp
  (6297): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->Login(09/16/2015 10:19:23.571 [004900] [4272] :
  SqlApi.cpp          (6307): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->Password(09/16/2015 10:19:23.667 [004900]
  [4272] : SqlApi.cpp          (6911):
  SQLAPI-CSqlApi::LogoffServer >>>>> enter 10:19:23
  09/16/2015 10:19:23.667 [004900] [4272] : SqlApi.cpp
  (6928): SQLAPI-CSqlApi::LogoffServer <<<<< exit rc(0):RC_OK
  10:19:23
  09/16/2015 10:19:23.676 [004900] [4272] : SqlApi.cpp
  (6514): SQLAPI-CSqlApi::LogonServer Failed to connect to server
  2008SQL-TEST.
  A connection was successfully established with the server, but
  then an error occurred during the login process. (provider: SSL
  Provider, error: 0 - The target principal name is incorrect.)
  The target principal name is incorrect (HRESULT:0x80131501)
  09/16/2015 10:19:23.676 [004900] [4272] : SqlApi.cpp
  (6523): SQLAPI-CSqlApi::LogonServer <<<<< exit rc(1900):RC_OK
  10:19:23
  09/16/2015 10:19:23.676 [004900] [4272] : errormsg.cpp        (
  202): Enter agentRcMessage(),
    agentRc : 1900
  09/16/2015 10:19:23.676 [004900] [4272] : errormsg.cpp        (
  349): Exit agentRcMessage(), msgNum = 5424
  09/16/2015 10:19:23.678 [004900] [4272] : SqlApi.cpp          (
  975): SQLAPI-CSqlApi::GetSqlServerInfo ACO5424E Could not
  connect to SQL server; SQL server returned:
  Failed to connect to server 2008SQL-TEST.
  A connection was successfully established with the server, but
  then an error occurred during the login process. (provider: SSL
  Provider, error: 0 - The target principal name is incorrect.)
  The target principal name is incorrect (HRESULT:0x80131501)
  
  Windows
  Event ID: 36884
  The certificate received from the remote server does not contain
  the expected name. It is therefore not possible to determine
  whether we are connecting to the correct server. The server name
  we were expecting is 2008sql1201. The SSL connection request has
  failed. The attached data contains the server certificate.
  
  
  Data Protection Versions Affected:
  IBM Tivoli Storage Manager for Databases: Data Protection for
  SQL version:  7.1.x
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of:                                                    *
  * - Tivoli Storage Manager for Databases: Data Protection for  *
  * Microsoft SQL Server 6.3, 6.4, and 7.1                       *
  * - Tivoli Storage FlashCopy Manager for Microsofot SQL Server *
  * 3.1, 3.2, and 4.1                                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This fix is currently     *
  * projected to be available in:                                *
  *                                                              *
  *   Tivoli Storage Manager for Databases: Data Protection for  *
  * Microsoft SQL Server 7.1.6                                   *
  *   Tivoli Storage Manager for Databases: Data Protection for  *
  * Microsoft SQL Server7.1.4.1 interim fix                      *
  *   Tivoli Storage FlashCopy Manager for Microsoft SQL Server  *
  * 4.1.6                                                        *
  *                                                              *
  * Note: This information is subject to change at the           *
  * discretion of IBM.                                           *
  * Note 2: Until a FlashCopy Manager for Microsoft SQL Server   *
  * fix is available, FlashCopy Manager customers can install    *
  * and use the Data Protection for Microsoft SQL Server fix.    *
  * When installed into a FlashCopy Manager for Microsoft SQL    *
  * Server environment, the Data Protection for Microsoft SQL    *
  * Server fix provides equivalent functionality.                *
  ****************************************************************
  

Problem conclusion

• FlashCopy Manager for Microsoft SQL Server and Data Protection
  for Microsoft SQL Server have been updated to use the new
  Microsoft SQL Server "ENABLESQLFQdn" configuration option.
  

Temporary fix

• Tivoli Storage Manager for Databases: Data Protection for
  Microsoft SQL Server7.1.4.1 interim fix
  Tivoli Storage FlashCopy Manager for Microsoft SQL Server
  4.1.4.2
  

Comments

APAR Information

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

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

Modules/Macros

• fmux
  

Fix information

• Fixed component name

  TDP FOR SQL WIN

• Fixed component ID

  5698DPSAP

Applicable component levels