5 Replies Latest reply on Sep 14, 2021 11:15 PM by Mohanraj Palanisamy

    IICS

    srini komm Seasoned Veteran
      I have created sql server connection using windows authentication v2 in iics. This connection was tested successfully and I can preview the data too. But when I tried to run the mapping in iics, the mapping failed with the following error
      CMN_1022 Database driver error... CMN_1022 [ [informatica][ODBC SQL Server Wire Protocol driver][SQL Server]Login failed for user 'abc'. Database driver error... Function Name : Connect Database driver error... Function Name : Connect Database Error: Failed to connect to database using user ‘abc’ and connection string [Driver=DataDirect CLOSED 8.0 SQL Server Wire Protocol for Informatica - R37;DB=xx;HOST=xxxxx;PORT=xxx;UID=abc ;WorkArounds2=2;EQI=1;AM=4;APP=Informatica;LoginTimeout=300;ConnectionRetryCount=10;ConnectionRetryDelay=1
      I checked with dba team and they informed me that they have not observed any logon failures on their end and also confirmed that user has required privileges.  Performed telnet and successfully connected to database server from IICS server. I have updated odbc drivers and updated windows registry on IICS server too.
      Can someone suggest any solution to fix this error?