4 Replies Latest reply on May 10, 2021 2:26 PM by Nitin KN

    SQL Connection Type

    Retro Flame Guru


      I installed secure agent in a VM server and established connection to Azure Synapse using Microsoft SQL Server Connection Type. Connection was tested and was successful but when I try to import data from synapse, I'm getting the following error-


      RR_4036 Error connecting to database [ [Informatica][ODBC SQL Server Wire Protocol driver]Cannot load trust store. %s1 Database driver error... Function Name : Connect Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [sv_anaplan_user] and connection string [Driver=DataDirect CLOSED 8.0 SQL Server Wire Protocol for Informatica - R36;DB=AZSYNAPSEDW01;HOST=egasynapsews.sql.azuresynapse.net;PORT=1433;UID=sv_anaplan_user;WorkArounds2=2;EQI=1;APP=Informatica;TimestampTruncationBehavior=1].].


      What is the cause for this error, also I noted in my runtime environment the process server was not running and showed error only data integration server was running.