Forum Discussion

andyor's avatar
andyor
Resolver I
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi andyor 

This error usually means that the client can't find the SQL Server instance. This normally happens when at least one of the following problems exist:

  • The name of the computer hosting the SQL Server
  • Instance does not resolve the correct IP
  • The TCP port number is not specified correctly

Checklist:

  • SQL Server are up are running
  • Check the correct instance name
  • Add in exception in firewall
  • Check if anti virus is using it
  • Check the SQL browser services

Please refer the following Microsoft document and cases that could also help you:

https://community.powerbi.com/t5/Desktop/SQL-Connection-error-Named-Pipes/td-p/29203

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15

https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

 

Best Regard

Community Support Team _ Ailsa Tao