Login failed for user 'XXXODSUser' while BOM Update

[HariCS23]

Hi, We are getting this below error while pusing BOMMAT idoc from ECC for only last two days.. wondering why this error coming without any config change.

nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'XXXODSUser'

Where in MII or ME we say to user this user ? I have checked MII in multiple places ,i see only two connections which are to WIP and INT database and those connections user XXXWIPUser,XXXINTUser.

Any idea on where this user info is configured ??

Thanks

Hari

[HariCS23]

Update 1: This looks like it is problem with link server connection in WIP DB to connect ODS Databse. But still we couldn't solve the whole issue.

Update2: Then we have changed XACT_ABORT value , and It started working.