Forum Discussion

Kazanskyi's avatar
Kazanskyi
Icon for Helper I rankHelper I
2 years ago

error: 40 - Could not open a connection to SQL Server

Can't set up a connection with a dataflow to the SQL Server through the gateway.   We use a gateway to connect to the SQL database in multiple reports with no issues, but the dataflow throws an err...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

Hi Kazanskyi 

 

From the error could you try and change the connection to use TCP/IP instead of Named Pipes?

Kazanskyi's avatar
Kazanskyi
Icon for Helper I rankHelper I
2 years ago

Hello GilbertQ ,

Sorry, I can't find any advanced settings to change it.