error: 40 - Could not open a connection to SQL Server

[kvitnitskiy]

Hi all.

 have an issue with connection to SQL server.  and this  just start  happens recently. before it works perfect. 

 I can connect to server succesfully via MSSMS but not via Power BI, it the same time if I add tcp:  before server name  - it works. 

and I noticed this connection server doesn't  work for me from my PC, using another PC with my credentials - works fine, looks like something on my PC doesnt let Power BI connect,  any ideas? 

p.s. Power BI  Version: 2.103.881.0 64-bit (March 2022), on previous version vas the same. 

[kvitnitskiy]

check if the outbound traffic over port 1433 port is allowed - YEs, other(6) SQL  servers works perfect 
 add firewall rules to specify which IP address ranges - I dont have access for it. 

[V-lianl-msft]

Hi @kvitnitskiy ,

1. Please check if the outbound traffic over port 1433 port is allowed on the machine which has desktop runs.

2. Please add firewall rules to specify which IP address ranges from the Internet are allowed. See: Azure SQL Database server-level and database-level firewall rules.

3. Go to File Menu > Options and Settings > Data Source Setting then clear the permission for datasource. Then use servername,port as server in Power BI Desktop to connect to SQL database

You can also refer to these threads:

https://community.powerbi.com/t5/Power-Query/Failed-to-connect-to-SQL-Server/td-p/28939 

https://community.powerbi.com/t5/Desktop/Able-to-connect-to-database-using-SSMS-But-not-via-Power-BI... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.