topic Re: Can not connect to SQL from VM in Report Server

Can not connect to SQL from VM

MrMP — Sun, 25 Oct 2020 12:51:21 GMT

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!

Re: Can not connect to SQL from VM

FarhanAhmed — Mon, 26 Oct 2020 05:55:12 GMT

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

Re: Can not connect to SQL from VM

MrMP — Mon, 26 Oct 2020 07:57:37 GMT

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

Re: Can not connect to SQL from VM

FarhanAhmed — Mon, 26 Oct 2020 09:11:29 GMT

Can you please share the error & screenshot of it?

Re: Can not connect to SQL from VM

MrMP — Mon, 26 Oct 2020 09:19:09 GMT

"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.)"

Re: Can not connect to SQL from VM

FarhanAhmed — Mon, 26 Oct 2020 09:48:49 GMT

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-the-sql-server-database-engine?view=sql-server-ver15

Re: Can not connect to SQL from VM

MrMP — Mon, 26 Oct 2020 10:06:36 GMT

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=20476

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

The wait operation timed out

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

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

Re: Can not connect to SQL from VM

FarhanAhmed — Mon, 26 Oct 2020 10:29:00 GMT

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