External Data for Confluence

Matthew Buchanan July 22, 2020

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.

2 answers

1 accepted

2 votes
Answer accepted
Matthew Buchanan September 25, 2020

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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 25, 2020

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

Thomas Opiolka
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 28, 2020

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

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 23, 2020

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 July 28, 2020

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.

Like Nic Brough -Adaptavist- likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events