Alteryx Designer Desktop Discussions

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

Error when trying to connect a db

Ronal_bal
8 - Asteroid

Hi, 

I'm facing this issue when trying to connect with a db. tried to manually extend the connection timeout = 500. But still couldn't able to fix it. Someone have any idea?


Error: Input Data (1): Error opening connect string: Microsoft SQL Server Native Client 11.0: Login timeout expired\HYT00 = 0; Microsoft SQL Server Native Client 11.0: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online; Microsoft SQL Server Native Client 11.0: Named Pipes Provider: Could not open a connection to SQL Server 

4 REPLIES 4
IraWatt
17 - Castor
17 - Castor

Not sure how to extend the timeout but are you sure its a internet speed issue? There are quite a few other things that could be causing that issue A network-related or instance-specific error occurred - SQL Server | Microsoft Docs

Ronal_bal
8 - Asteroid

That's the error I'm receivingThat's the error I'm receiving

ddiesel
13 - Pulsar
13 - Pulsar

Hi @Ronal_bal!

 

Is this happening intermittently or constantly?

Ronal_bal
8 - Asteroid

It got resolved, Some old db. issue.

Labels
Top Solution Authors