Is anyone using this app (External Data for Confluence)?
I am having some difficulty in setting up the connection for a MSSQL database. I have worked with our vendor to make sure the external IP addresses were whitelisted. I have also tried multiple combinations of usernames, passwords, database names (including paths and not including paths, etc. and continue to get an error message that I have not been able to resolve:
Connect Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught) - A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
I have not emailed their support yet - I wanted to check with the Atlassian Community first.
Since I posed the question, I thought I would also pose the answer.
After much assistance from codefortynine and the company that I contract our network support through, we determined that the answer was to update TLS on our SQL Server from 1.0 to 1.2.
Once this update was performed, I was able to connect to my database and am now happily posting data to my Confluence page.
I did email their support around the same time that I posted my question here. They have been responsive, but I cannot say (yet) if they have been helpful.
Once I find what the issue is, I plan to post how I resolved it here so that if anyone else has issues, they will have something to give a shot.