Forum Discussion

doug_fossler's avatar
doug_fossler
New Contributor
6 years ago

Failed To Mount when attempting to attach file using Email Sender

I have several pipelines that use the Email Sender to attach a document to the email. These are all failing now with the error saying that “Mount failed due to logon failure or bad credentials:” Th...
General Information
tharunm's avatar
tharunm
New Contributor II
4 years ago
Copy LinkReport

Hello Community,

Anyone faced similar issue as I before? Could you share what steps are to be followed to get this resolved this issue.

Thank you.

mbowen's avatar
mbowen
Employee
4 years ago
Copy LinkReport

Hi @tharunm

You had posted a previous message in community with less information. This connection error is being returned from the SQL server driver. “null” is suspect here, and suggests something isn’t defined or can’t be reached.

It may be a firewall issue. I assume you’ve verified the credentials. Can you verify that you are indeed able to connect to this host and port.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1300d370-3736-431b-8912-a0152779453c/unable-to-open-port-no1433?forum=sqlgetstarted

  • tharunm's avatar
    tharunm
    New Contributor II
    4 years ago
    Copy Link

    Hi @mbowen and @siwadon,

    The current issue I encounter is, I am able to connect the SQL server outside snaplogic but not with snaplogic.

    There were two errors, one while using groundplex(which is preferred) and an other using cloudplex.

    Also, there are other SQL servers accounts which I’ve created in the past and still working on with them. So, for this account alone I see ‘Unexpected rethrowing’ error.

    I really appreciate your responses. Thank you.

    • mbowen's avatar
      mbowen
      Employee
      4 years ago
      Copy Link

      A couple things to try on your Groundplex.

      • If you don’t specify a JDBC jar, the SQL Server snap pack will use the jdbc driver bundled with the snap pack (a 4.0 driver). So, try that if you haven’t already.

      • Try adding this property to the Url Properties at the bottom of the account.

      trustServerCertificate=true

      • If neither of the above help, let’s trying pinning the TLS version. Add this property to Url Properties. Try v1 then v1.2. I’m not sure of TLS version enabled for 2016 sql server.

        sslProtocol=TLSv1
        OR
        sslProtocol=TLSv1.2

      Let us know results.

      • tharunm's avatar
        tharunm
        New Contributor II
        4 years ago
        Copy Link

        Hi Bowen,
        many thanks for your response.

        I have tried again with 4 different JDBC drivers, and also the default ones(by not specifying anything) and also by adding the URL properties as mentioned above, adding one at a time and both of the properties at a time, in my Dev and Test environments on 4 different groundplexes and yet the error remains the same. ‘Unexpected Rethrowing’ as the driver couldn’t establish a secure connection to SQL server.

        so, we are still at square one I suppose.

        Thanks.