Problems connecting to SQL
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I just upgraded to Alteryx 11.5 and my workflows connecting to Microsoft SQL server are no longer working. When I open my workflow I see this:
When I try to reconfigure the Input Data tile and click on Microsoft SQL Server I get this:
Finally, when I try to close and restart, I have to force it close from Windows Task Manager as I get this:
Please help!
Katie
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There appears to be a problem with one of the XML files that is storing your Alias for SQL Server. The file is in C:\ProgramData\Alteryx\Engine\System.xml or C:\ProgramData\Alteryx\Engine\User.xml depending on whether or not your alias is a User or System type connection. If you have a non Admin install the same files exist under C:\Users\<your name here>\AppData\Roaming\Alteryx\Engine
If you rename these files you will no longer crash, but you won't have your Aliases any longer. If you want to send me your XML file I can see what is wrong and we can try to fix it.
Thank you
Linda
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Linda,
I'm not sure if I have admin or not, but I've attached what I found in the non-admin path. Is this what you're looking for?
Thanks so much for helping me through this, I'm not very tech savvy :)
Katie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That is perfect. Thank you. I can reproduce your error and will get back to you shortly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your assistance Linda! Renaming the .xml files worked.
Katie
