Forum Discussion

Helper I

5 years ago

Solved

Impossible to connect to sql server

Hi everyone, I have Power BI desktop in my computer and I am trying to get an external server with Windows Server 2003 and SQL server 2005. I clicked on Get Data and I get the following error: ...

TatianaGuihur
5 years ago
Hi amitchandak.

Finally I got the connection. The issue was that i was using the port number 2437 instead of 1339.

Everything is working right now. Thanks for your help.

Super User

5 years ago

TatianaGuihur , You are not able to reach SQL Server. Are you able to connect the same using SQL server management studio?

Is Connection details, the port is correct. VPN or IP whitelist is in place?

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

Helper I

5 years ago

Hi amitchandak thank you for your answer.

Yes I am able to connect to the database using SQL server management studio.

However I am not sure about the VPN or IP whitelist. How and where can I check those??

Thanks again.