Forum Discussion
Getting an error when connecting to SQL Server in Power BI
- 5 years ago
Hi, shantanugupta
Have you followed amitchandak’s suggestion to try IP address instead of using server name and check if it can work?
If not, you can also try these steps that may help according to my research:
- check the login details and server name
- login to SQL Server Management Studio with same details
- turn off proxy.
- turn off the firewall.
- check if all TCP\IP configurations in the configuration manager enabled.
- check all set to port 1433
Here are some cases that have a similar error as yours, you can also take a look:
https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/28645
https://community.powerbi.com/t5/Desktop/sql-connection-time-out-from-power-bi-desktop/m-p/17307
https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-SQL-server/m-p/79157
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, shantanugupta
Have you followed amitchandak’s suggestion to try IP address instead of using server name and check if it can work?
If not, you can also try these steps that may help according to my research:
- check the login details and server name
- login to SQL Server Management Studio with same details
- turn off proxy.
- turn off the firewall.
- check if all TCP\IP configurations in the configuration manager enabled.
- check all set to port 1433
Here are some cases that have a similar error as yours, you can also take a look:
https://community.powerbi.com/t5/Desktop/Unable-to-Connect-to-SQL-Server/m-p/28645
https://community.powerbi.com/t5/Desktop/sql-connection-time-out-from-power-bi-desktop/m-p/17307
https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-SQL-server/m-p/79157
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.