Forum Discussion

Helper 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 error.

4 Replies

GilbertQ
Super 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
  Helper I
  2 years ago
  Hello GilbertQ ,
  Sorry, I can't find any advanced settings to change it.
GilbertQ
Super User
2 years ago
Hi Kazanskyi

That should be on the datasource settings in the Gateway where you can change that!
- Kazanskyi
  Helper I
  2 years ago
  Hi GilbertQ ,
  
  Sorry, I can't find it in the Gateway data source settings as well.