Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Get started Tell me more

Atlassian Community about banner

4,554,229

Community Members

Community Events

184

Community Groups

Community
Products
Jira Align
Questions
New Error When Connecting from Alteryx Gallery (server)

New Error When Connecting from Alteryx Gallery (server)

Recently began receiving an error message when trying to connect to Enterprise Insights from Alteryx.

Error opening Connection String: Cannot create data source object

This only happens on Alteryx Server. Works fine on Alteryx desktop.

So, cannot save or run on Alteryx Server any longer.

2 answers

1 accepted

0 votes

Answer accepted

@Jason Davis Is your Alteryx Server on your corporate network and is its IP address within the IP addresses that is whitelisted on your Enterprise Insights instance?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sam. Yes to both questions.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Does Alteryx Server use port 1433 outbound to connect to Enterprise Insights? I'm guessing that it does. Are there different firewall rules for Alteryx Server? The reason why I am asking these questions because you can connect to Enterprise Insights with Alteryx Desktop which confirms that you can connect from your corporate network. This is most likely specific to Alteryx Server. Since Alteryx Server isn't able to connect to Enterprise Insights, there is nothing that can be seen on the Enterprise Insights side to help troubleshoot the issue.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

I agree with that. Thanks Sam.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

hey Sam, can I email you directly? Want to discuss our IP addresses that you have whitelisted on your side. Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

please email me at jason.davis4@wnco.com

thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

@Jason Davis I recommend opening a ticket with the Atlassian support team and they can help you with this. Here is a link to the Jira Align support portal: https://support.atlassian.com/jira-align/

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

0 votes

Sam, has anything changed recently regarding the SQL Server database that would not allow us to connect from server but desktop would be fine? Just reaching here as we cannot find a solution internally. Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Jason Davis There hasn't been any changes to permissioning on EI. Does Alteryx Server require permissions to the master DB for SQL DBs? I've seen this before as an issue on another tool. With EI we don't allow permissions to the master DB.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS