My Oracle Support Banner

'ODI-1228: Task LKM MSSQL to MSSQL (LINKED SERVERS) (Add linked server) fails on the target MICROSOFT_SQL_SERVER connection' Signalled When Running ODI 12c Mapping Using LKM MSSQL to MSSQL (LINKED SERVERS) (Doc ID 1909089.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


When executing an ODI version 12.1.2 Mapping using the LKM MSSQL to MSSQL (LINKED SERVERS) to load data from a Microsoft SQL Server source database to a Microsoft SQL Server staging area database using the native linked servers feature, the following messages are observed in ODI Operator:

LKM step Drop mapped login for linked server, shows warning: 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.