Resolving Adapter failed to transmit message going to send port with URL. It will be retransmitted after the retry interval specified for this Send Port. Details:"System.ArgumentNullException: Value cannot be null. Parameter name: Password error in BizTalk Server

Error - The adapter failed to transmit message going to send port "SendPort1” with URL "mssql://56.168.120.78/maqerdgerdom/FERTERDT?". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.ArgumentNullException: Value cannot be null.

Parameter name: Password. 

Here SendPort1 is a WcfSql send port, we get the System.ArgumentNullException for the Wcf-Sql Port when the configuration of the port is not complete i.e. some of the details required for the port are not configured.

Here the Parameter name is clearly specified as - Password, hence we need to check the Password configured for the WcfSql Send Port.

As per the above error the Password would have not been configured hence it’s saying null value.

Note - In a Binding file the password information will not be stored, hence when we import a Binding file, Password will not configured for Send Port, it has to be configured again