IBM Support

PI22444: [wi 120380]Document SQL Server Windows Authentication (Windows Integrated Security) is not supported

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When attempting to install/setup Rational Asset Manager 7.5.2
    and setup an SQL Server database for Rational Asset Manager
    (RAM) or Rational Team Concert (RTC) database login errors are
    encountered. The RAM Information Center does not document that
    Windows Authentication is not supported.
    
    SystemOut.log in WebSphere Application Server (WAS) v8.5.x shows
    SQL Server login errors
    when doing RAM Setup for the SQL Server 2008 database for RAM
    and RTC.
    
    "...
    ************ Start Display Current Environment ************
    WebSphere Platform 8.5.5.2 [BASE 8.5.5.2 cf021414.01] running
    with
    process name HPESSDCPFQ01VNode01Cell\HPESSDCPFQ01VNode01\server1
    and
    process id 1300
    Host Operating System is Windows Server 2008 R2, version 6.1
    Java version = 1.6.0, Java Compiler = j9jit26, Java VM name =
    IBM J9 VM
    was.install.root = C:\Program Files
    (x86)\IBM\WebSphere\AppServer
    user.install.root = C:\Program Files
    (x86)\IBM\WebSphere\AppServer\profiles\RAM
    Java Home = C:\Program Files
    (x86)\IBM\WebSphere\AppServer\java\jre
    ...
    ..
    .
     com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
        at
    com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)
    [5/27/14 11:34:59:751 PDT] 000000b9 SystemOut     O 11:34:59,751
    [WebContainer : 0] ERROR com.ibm.ram.repository.setup.web
         - CRRAM703I: Database - CRRAM3004E - In the server setup
    application, an error occurred with the message Login failed for
    user
    'sdrb\ibm.jazz.adm'.
    ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db,
    SQLSTATE=S0001, and SQL Error code=18,456. For more information,
    see
    Rational Asset Manager help system.
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed
    for user
    'sdrb\ibm.jazz.adm'.
    ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db
        at....
    .."
    
    The following RAM 7.5.2 documentation items fail to state
    Windows Authentication is not supported with the Microsoft SQL
    Server database:
    
    - Creating a database for assets in Microsoft SQL Server
    http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.ibm.r
    am.installguide.doc/topics/configuring_SQL2005.html
    
    - Creating databases for asset lifecycles in Microsoft SQL
    Server
    http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.ibm.r
    am.installguide.doc/topics/t_database_RTC_lifecycle_MsSQL.html
    
    Under the section "Before you begin", it should state
    
    * Windows Authentication (== Windows Integrated Security) is not
    supported by RAM or RTC setup.
    Use SQL Server Authentication available as part of Mixed mode (
    Windows Authentication and SQL Server Authentication).
    
    
    References:
    - RTC APAR
    PI18955: [WI 233472] DOCUMENT THAT "INTEGRATED AUTHENTICATION"
    IS NOT SUPPORTED
    https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI18955
    
    - The Support Authority: Resolving connection errors between
    WebSphere Application Server and SQL Server
    http://www.ibm.com/developerworks/websphere/techjournal/1011_sup
    auth/1011_supauth.html
    

Local fix

  • Use SQL Server Authentication.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * none                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When attempting to install/setup Rational Asset Manager      *
    * 7.5.2                                                        *
    * and setup an SQL Server database for Rational Asset Manager  *
    * (RAM) or Rational Team Concert (RTC) database login errors   *
    * are                                                          *
    * encountered. The RAM Information Center does not document    *
    * that                                                         *
    * Windows Authentication is not supported.                     *
    *                                                              *
    * SystemOut.log in WebSphere Application Server (WAS) v8.5.x   *
    * shows                                                        *
    * SQL Server login errors                                      *
    * when doing RAM Setup for the SQL Server 2008 database for    *
    * RAM                                                          *
    * and RTC.                                                     *
    *                                                              *
    * "...                                                         *
    * ************ Start Display Current Environment ************  *
    * WebSphere Platform 8.5.5.2 [BASE 8.5.5.2 cf021414.01]        *
    * running                                                      *
    * with                                                         *
    * process name                                                 *
    * HPESSDCPFQ01VNode01Cell\HPESSDCPFQ01VNode01\server1          *
    * and                                                          *
    * process id 1300                                              *
    * Host Operating System is Windows Server 2008 R2, version 6.1 *
    * Java version = 1.6.0, Java Compiler = j9jit26, Java VM name  *
    * =                                                            *
    * IBM J9 VM                                                    *
    * was.install.root = C:\Program Files                          *
    * (x86)\IBM\WebSphere\AppServer                                *
    * user.install.root = C:\Program Files                         *
    * (x86)\IBM\WebSphere\AppServer\profiles\RAM                   *
    * Java Home = C:\Program Files                                 *
    * (x86)\IBM\WebSphere\AppServer\java\jre                       *
    * ...                                                          *
    * ..                                                           *
    * .                                                            *
    * ¶                                                            *
    * com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) *
    * ¶  ¶  at                                                     *
    * com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)  *
    * [5/27/14 11:34:59:751 PDT] 000000b9 SystemOut ¶  ¶  O        *
    * 11:34:59,751                                                 *
    * [WebContainer : 0] ERROR com.ibm.ram.repository.setup.web    *
    * ¶  ¶  ¶ - CRRAM703I: Database - CRRAM3004E - In the server   *
    * setup                                                        *
    * application, an error occurred with the message Login failed *
    * for                                                          *
    * user                                                         *
    * 'sdrb\ibm.jazz.adm'.                                         *
    * ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db,     *
    * SQLSTATE=S0001, and SQL Error code=18,456. For more          *
    * information,                                                 *
    * see                                                          *
    * Rational Asset Manager help system.                          *
    * com.microsoft.sqlserver.jdbc.SQLServerException: Login       *
    * failed                                                       *
    * for user                                                     *
    * 'sdrb\ibm.jazz.adm'.                                         *
    * ClientConnectionId:0fe9aa4d-3027-4fc8-a0ce-989d368fd0db      *
    * ¶  ¶  at....                                                 *
    * .."                                                          *
    *                                                              *
    * The following RAM 7.5.2 documentation items fail to state    *
    * Windows Authentication is not supported with the Microsoft   *
    * SQL                                                          *
    * Server database:                                             *
    *                                                              *
    * - Creating a database for assets in Microsoft SQL Server     *
    * http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.i *
    * bm.r                                                         *
    * am.installguide.doc/topics/configuring_SQL2005.html          *
    *                                                              *
    * - Creating databases for asset lifecycles in Microsoft SQL   *
    * Server                                                       *
    * http://pic.dhe.ibm.com/infocenter/ramhelp/v7r5m2/topic/com.i *
    * bm.r                                                         *
    * am.installguide.doc/topics/t_database_RTC_lifecycle_MsSQL.ht *
    * ml                                                           *
    *                                                              *
    * Under the section "Before you begin", it should state        *
    *                                                              *
    * * Windows Authentication (== Windows Integrated Security) is *
    * not                                                          *
    * supported by RAM or RTC setup.                               *
    * Use SQL Server Authentication available as part of Mixed     *
    * mode (                                                       *
    * Windows Authentication and SQL Server Authentication).       *
    *                                                              *
    *                                                              *
    * References:                                                  *
    * - RTC APAR                                                   *
    * PI18955: [WI 233472] DOCUMENT THAT "INTEGRATED               *
    * AUTHENTICATION"                                              *
    * IS NOT SUPPORTED                                             *
    * https://www-304.ibm.com/support/entdocview.wss?uid=swg1PI189 *
    * 55                                                           *
    *                                                              *
    * - The Support Authority: Resolving connection errors between *
    * WebSphere Application Server and SQL Server                  *
    * http://www.ibm.com/developerworks/websphere/techjournal/1011 *
    * _sup                                                         *
    * auth/1011_supauth.html                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI22444

  • Reported component name

    RATL ASSET MGR

  • Reported component ID

    5724R4200

  • Reported release

    752

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-21

  • Closed date

    2015-03-10

  • Last modified date

    2015-03-10

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

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

Fix information

Applicable component levels

  • R752 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUS84","label":"Rational Asset Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"752","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 April 2022