We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

GCSE-519:SQL Server Quick Connect missing Test connection button with Windows Authentication Type to populate Default Database list

JoshHP
Alteryx Alumni (Retired)
Created

Environment Details

 

The Test button is missing for Windows Authentication type connection when adding a SQL Server Database Connection via the Input Data tool’s SQL Server Quick Connect,

 image.jpegimage.jpeg
  • Alteryx Designer
    • Version 2022.1
  • Third Party products 
    • SQL Server
  • Additional Tools
    • SQL Server Quick Connect 

 


Cause

Defect GCSE-519 will be fixed in a future release
 

 

Resolution

 

Solution A

Use DSN connection instead of Quick Connect. How to connect to an ODBC data Source
 

Additional Resources