Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Trouble Connecting to SQL Server

TWerner
5 - Atom
‎08-25-2017 09:11 AM

Hello,

 

I'm consistently getting an error when I'm attempting to establish a SQL Server Database Connection.  Our IT department recently switched us to ODBC requirements, and it's been a bit of a chore for me ever since.  Other coworkers seemingly have the same settings as I do, but they don't get the error.

 

I'm not sure what I should share to help with the error, since the process isn't very involved.

 

 

Here is the test results window from the ODBC Admin...

Microsoft ODBC Driver for SQL Server Version 12.00.4100

Running connectivity tests...

Attempting connection
[Microsoft][ODBC Driver 11 for SQL Server]SSL Provider: No process is on the other end of the pipe.

[Microsoft][ODBC Driver 11 for SQL Server]Client unable to establish connection

TESTS FAILED!

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
TWerner
5 - Atom
‎08-25-2017 12:52 PM

Using a different driver fixed this for me.  Using the Native SQL one.

Reply
0 Likes
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All