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.

[Nic Brough -Adaptavist-]

You can have as many as you want.  Although each one will be on a different url.

[MariaT]

The situation will be this:

• 1 JIRA software with 50 users and 50 users for Confluence
• 1 JIRA software with 100 users and 100 user for Confluence

All this users can access to the same confluence, without buying new licences?

Thanks

[Nic Brough -Adaptavist-]

No.  You have Confluence 1 with 50 users, and Confluence 2 with 100.  You will have to licence the two servers separately, and give the 50/100 users the right memberships.  If there are some of the 50 that need access to both, you will need to add them to both, and they'll use up a licence "seat" in each one.