OBIA 184.108.40.206: SQL Server Database Connection Issues In Informatica 10.1
(Doc ID 2323216.1)
Last updated on DECEMBER 11, 2019
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11 and later
Information in this document applies to any platform.
Intermittent SQL Server 2014 database connection timeout issues in Informatica 10.1.
The failure can occur on any workflow that is connecting to SQL Server 2014 Data Warehouse. This works after restarting the task .
WRITER_16_*_1> WRT_8147 Writer: Target is database [<DB>], user [<USER>], bulk mode [OFF]
WRITER_16_*_1> WRT_8001 Error connecting to database...
WRT_8001 [Session SIL_PositionDimensionHierarchy_Type1AsIsUpdate Username <USER> DB Error -1800 Microsoft SQL Server Native Client 11.0: Login timeout expired
SQL State: HYT00 Native Error: 0
Microsoft SQL Server Native Client 11.0: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Microsoft SQL Server Native Client 11.0: Named Pipes Provider: Could not open a connection to SQL Server .
SQL Server Message: Named Pipes Provider: Could not open a connection to SQL Server .
Database driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [<USER>] and connection string [<CONNECTSTRING>].]
Tried with the Informatica Integration Service Extended Parameter (MSSQLInitTimeout) and increased this to 120 but still get the same issues.
Upgraded Informatica and the SQL server
From: Informatica 9.1 connecting to SQL Server 2008 R2
To: Informatica 10.1 against SQL Server 2014
Used OLEDB and it is a deprecated connection and hence changed the connection to ODBC for MS SQL Server.
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