Forum Discussion
Error attempting to setup gateway connection for SQL database on local server
Hi Getting the following error when attempting to setup gateway connection to a SQL server database on a local server. I had no ttrouble when setting up a gateway connection to a CSV file in oned...
Hey andyor ,
what type of gateway are you using:
- on-premises standard installation (aka enterprise gateway), recommended!
- on-premises local installation
Is the gateway installed on a dedicated machine that is close to the SQL server instance, on your local desktop/laptop, or on the same machine? Make sure that you are able to ping the SQL server machine from the gateway machine. This, of course, is mandatory.
Check if the TCP/IP network protocol is enabled for the SQL Server instance you can test this using SQL Server configuration manager tool:
Check if the SQL Server instance allows remote connections, you can check the property of the instance using SQL Server Management Studio:
Hopefully, one of the mentioned aspects helps to tackle your challenge.
Regards,
Tom