Service Operations Insight

Getting CMS database error: STW00226 during CABI installation

  • 1.  Getting CMS database error: STW00226 during CABI installation

    Broadcom Employee
    Posted Feb 25, 2014 10:59 AM

    Installing CABI to use existing CMS and Audit databases on Microsoft SQL.

    Why do you get the following error during the database validation

     CMS database error: STW00226
     
     BusinessObjects Enterprise CMS: Unable to connect to the CMS system
     database "cmsdb".
     Reason: [Microsoft][ODBC Driver Manager] The specified DSN contains an
     architecture
     mismatch between the Driver and Application.

    You get the problem if you setup the System DSN using the 64-bit Database Sources (ODBC)
    You need to setup the System DSN using the 32-bit Data Sources (ODBC)
    by running c:\windows\SysWOW64\odbcad32.exe