nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

New Error When Connecting from Alteryx Gallery (server)

Jason Davis_7jaodk

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.

Accepted answers

Sam Tsubota

@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?

All comments

Sam Tsubota

@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?

Jason Davis_7jaodk

Hi Sam. Yes to both questions.

Sam Tsubota

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.

Jason Davis_7jaodk

I agree with that. Thanks Sam.

Jason Davis_7jaodk

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

Sam Tsubota

@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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-align

alteryx

enterprise-insights