External Data for Confluence

[Matthew Buchanan]

Is anyone using this app (External Data for Confluence)?

https://marketplace.atlassian.com/apps/1221733/external-data-for-confluence?hosting=cloud&tab=support

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.

[Matthew Buchanan · Accepted solution]

Good afternoon!

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.

[Nic Brough -Adaptavist-]

Thank you - we all appreciate a good answer, whatever the source!

[Thomas Opiolka - codefortynine]

Thank you @Matthew Buchanan again for your patience in support. I am glad that a solution was found in the end. Don't hesitate to contact us again in case you have further questions.

Best,
Thomas

[Nic Brough -Adaptavist-]

I think you need to head for a support issue - it looks like the app cannot handle whatever authentication your ms-sql is doing (while I suspect you've got other tools that can)

[Matthew Buchanan]

Thanks Nic!

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.