topic Sql server not connecting through power bi in Virtual Machine in Report Server

Sql server not connecting through power bi in Virtual Machine

Rt-idsp — Thu, 26 May 2022 10:53:24 GMT

Hello Members,
I am unable to connect to sql server database from my power bi which is installed in my VM.

So basically I'm under client;s vm which has Power bi Desktop and from there I am unable to connect to their sql server database.
Please look at the SS for error.

Error Message:

Re: Sql server not connecting through power bi in Virtual Machine

FarhanAhmed — Thu, 26 May 2022 11:09:27 GMT

Kindly check below discussion on same issue

The semaphore timeout period has expired. - Microsoft Q&A

Azure SQL DB Connection fails intermittently from SSMS - Microsoft Q&A

Connectivity to SQL Server on Azure Error: 121 - The semaphore timeout period has expired - Database Administrators Stack Exchange

sql server - SQL - an error occurred during the pre-login handshake - Server Fault

Re: Sql server not connecting through power bi in Virtual Machine

Anonymous — Tue, 31 May 2022 02:24:48 GMT

Hi Rt-idsp ,

In regards to this specific error "Tcp provider error 0 - the semaphore timeout period has expired " this is a commonly caused by an intermittent network issue or SQL Server that is experiencing issues with hardware or being overloaded.

Here is an additional link that can help with troubleshooting these types of generic connection errors:

Thread A

Thread B

For more you can refer to the Original post Tcp provider error 0 - the semaphore timeout period has expired

Best Regards,
Community Support Team _ Caitlyn

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