Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
MrMP
Helper III
Helper III

Can not connect to SQL from VM

Hi All,

 

I have Power BI desktop installed on virtual machine with Static IP. That IP is whitelisted at clients SQL server (sqlexpress). Auth is basic and I have user and password. No matter what I try I cant connect to the db and view they created. What am I missing? Do I need to whitelist any other IP. The idea is to have gateway on VM and have it refresh the report from their SQL server.

Thank you for any help, I am new to this!

1 ACCEPTED SOLUTION
FarhanAhmed
Community Champion
Community Champion

You need to allow remote connections for your SQL in VM

 

you can follow steps from these articles to solve the problem

 

https://medium.com/@nishancw/how-to-enable-remote-connections-to-sql-server-dc5b6c812b5

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

7 REPLIES 7
FarhanAhmed
Community Champion
Community Champion

Try run Power BI Desktop as "Run As Administrator" and see if it still persists.







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Thank you for the answer but that did not help. Any other suggestions? Do they have to whitelist any other IP?

 

FarhanAhmed
Community Champion
Community Champion

Can you please share the error & screenshot of it?







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




"Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)"

FarhanAhmed
Community Champion
Community Champion

This error doesn't look like a Whitelist issue,

Are you able to log in thru SSMS from your machine where PBI Desktop is installed?

 

Take a look at this article

 

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-th...

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




I couldnt. This is the error:

 

"

TITLE: Connect to Server
------------------------------

Cannot connect to xxxxx.xxxx.xx\sqlexpress.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.) (Microsoft SQL Server, Error: 258)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&Evtsrc=MSSQLServer&EvtID=258&LinkId...

------------------------------

The wait operation timed out

------------------------------
BUTTONS:

OK
------------------------------"

FarhanAhmed
Community Champion
Community Champion

You need to allow remote connections for your SQL in VM

 

you can follow steps from these articles to solve the problem

 

https://medium.com/@nishancw/how-to-enable-remote-connections-to-sql-server-dc5b6c812b5

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.