Forum Discussion

Helper III

5 years ago

Solved

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

SQL

FarhanAhmed
5 years ago
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

MrMP

Helper III

5 years ago

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

FarhanAhmed