Extraction issue: SQLSTATE IM004 error

Use this procedure if you encounter an SQLSTATE IM004 error when extracting from a DB2 data source using an ODBC driver.

Note: 

Both the Microsoft SQL Server and SQL Server Agent on the SQL Server Configuration Manager need to use a Log on as account that belongs to one of these Windows groups:

  • DB2ADMNS

  • DB2USERS

To configure SQL for DB2 source using ODBC driver, follow these steps:

  1. From the Start menu, select Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager .
  2. In the SQL Server Configuration Manager, right- click SQL Server and select Properties.
  3. Set these:
    Log On tab

    On the Log On tab, set the Microsoft SQL Server to one of these:

    • An account that belongs to the DB2ADMNS or DB2USERS Windows groups

    • Local System account

  4. Click OK.
  5. Repeat the preceding steps for the SQL Server Agent.