IC91561: SQL SERVER LOGON FAILURE WHEN USING SQL AUTHENTICATION AND THE DATA PROTECTION FOR SQL COMMANDLINE INTERFACE

Download Information: Version 4.1 Tivoli Storage FlashCopy Manager
Download Information: Version 7.1 Tivoli Storage Manager for Databases

APAR status

• Closed as program error.

Error description

• When using the Tivoli Storage Manager for Databases Data
  Protection for MS SQL commandline interface, this fails to
  obtain the SQL Server log on information if the
  SQLAUTHentication= SQLuserid
  The output will show that it is attempting to use the default
  "sa" account to log on to the SQL Server:
    IBM Tivoli Storage Manager for Databases:
    Data Protection for Microsoft SQL Server
    Version 6, Release 4, Level 0.0
    (C) Copyright IBM Corporation 1997, 2012. All rights reserved.
   
    Connecting to SQL Server, please wait...
   
    ACO5424E Could not connect to SQL server; SQL server returned:
    Failed to connect to server SQLSRVR1.
    Login failed for user 'sa'. (HRESULT:0x80131501)
  A trace shows the failure to access the information from the
  registry:
    04/05/2013 15:10:20.592 [010320] [10304] : sqlreg.cpp ( 147):
     Enter getSqlAccountInfo()
    04/05/2013 15:10:20.592 [010320] [10304] :registry.cpp (611):
     Enter createOrOpenReg()
    04/05/2013 15:10:20.592 [010320] [10304] :registry.cpp (635):
     Exit createOrOpenReg()
    04/05/2013 15:10:20.592 [010320] [10304] :registry.cpp ( 155):
     Enter getSzValue()
    04/05/2013 15:10:20.592 [010320] [10304] :registry.cpp ( 185):
     error reading HKEY_LOCAL_MACHINE or HKEY_CLASSES_ROOT with a
     pathkey of SOFTWARE\IBM\ADSM\CurrentVersion\TDPSQL\SQLSRVR1
     and a keyword of USERA.
    04/05/2013 15:10:20.592 [010320] [10304] :sqlreg.cpp ( 182):
     SQL Server account not found.
    04/05/2013 15:10:20.592 [010320] [10304] :sqlreg.cpp ( 236):
     Exit getSqlAccountInfo()
    04/05/2013 15:10:20.593 [010320] [10304] :agtlog.cpp ( 380):
     Enter overloaded LogActivityLog
     msgNum : 5066
    04/05/2013 15:10:20.593 [010320] [10304] : agtlog.cpp ( 303):
     Enter LogActivityLog
     msgBuf : Error trying to obtain registry information. The
     default values for/SQLUSer and /SQLPassword will be used.
  .
  Initial Impact: medium
  Additional Keywords: TSM TDP DP FCM
  defect 92435
  

Local fix

• Use one of the following options to authenticate with the SQL
  Server logon:
   1. Use  SQL Server windows authentication
   2. Provide the SQLUSER and SQLPASSWORD as commandline
      parameters
   3. Use the  MMC GUI as this works successfully to save and
      utilize the stored registry information in its operations
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of:                                    *
  *                 Data Protection for Microsoft SQL Server     *
  *                 version 6.3 and 6.4, and Tivoli Storage      *
  *                 FlashCopy Manager for SQL Server version     *
  *                 3.1 and 3.2.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 fix is currently projected to be available   *
  *                 in:                                          *
  *                 - Data Protection for Microsoft SQL Server   *
  *                 6.4.1                                        *
  *                 - Tivoli Storage FlashCopy Manager 3.2.1     *
  *                 Note: This is subject to change at the       *
  *                 discretion of IBM.                           *
  ****************************************************************
  *
  

Problem conclusion

• Data Protection and FlashCopy Manager for SQL have been
  updated to be able to obtain SQL Server logon information
  while using SQL authentication and Data
  Protection for SQL commandline interface .
  

Temporary fix

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

• TDPSQLC  FCM      MMC
  

Fix information

• Fixed component name

  TDP FOR SQL WIN

• Fixed component ID

  5698DPSAP

Applicable component levels