Forum Discussion
Error Connecting the Gateway
Hello, dear comunity
I need your help as I am trying to connect the gateway but I get the following errors
Thank you
Hi Anonymous ,
Please check below:
- Please make sure your database engine is configured to accept remote connections.
- Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.
- Please check if your SQL server services is up and running properly.
- Please make sure that you enable TCP/IP in SQL Server Configuration
You can also refer the following links that could also help you:
- https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/
- https://community.powerbi.com/t5/Desktop/Not-able-use-data-source-configured-on-on-premises-data-gateway/td-p/60581
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
I tried to understand the Spanish in the picture and found the problem is that your gateway is old and configured incorrectly.
Solutions:
- Download the latest version of gateway(https://powerbi.microsoft.com/en-us/gateway/), recommend standard mode
- Install the gateway, sign in and register a new gateway until you see ‘The gateway xxx is online and ready to be used’
- Open power bi service, in Manage gateways page, choose the new gateway you have registered previously, select ‘ADD DATA SOURCE ’ on the left corner of the page, choose your Data Source Type and enter the information about data source, select Authentication Method and enter the credentials correctly, apply it. If all finished successfully, you can see ‘Connection Successful’ tag
For further information about gateway installation, please refer: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
If there is still something wrong, you can posted it for further discussion.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please check below:
- Please make sure your database engine is configured to accept remote connections.
- Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.
- Please check if your SQL server services is up and running properly.
- Please make sure that you enable TCP/IP in SQL Server Configuration
You can also refer the following links that could also help you:
- https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/
- https://community.powerbi.com/t5/Desktop/Not-able-use-data-source-configured-on-on-premises-data-gateway/td-p/60581
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.