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.
@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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
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.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.