Problems connecting to SQL

[KSmith307]

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

[LindaT · Accepted solution]

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

[KSmith307]

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

[LindaT]

That is perfect.  Thank you.  I can reproduce your error and will get back to you shortly.

[KSmith307]

Thank you for your assistance Linda!  Renaming the .xml files worked.

Katie