Forum Discussion
Power bi sql connection
Hi metecakmak ,
This is an article describes how to connect to your SQL on Azure virtual machine (VM).
More details: Connect to a SQL Server virtual machine on Azure
- The way a client connects to a SQL Server VM differs depending on the location of the client and the networking configuration.
If you provision a SQL Server VM in the Azure portal, you have the option of specifying the type of SQL connectivity.
- If you want to connect to your SQL Server database engine from the internet, select Public for the SQL connectivity type in the portal during provisioning.
- When you choose Private for the SQL connectivity type in the portal, Azure configures most of the settings identical to Public. The one difference is that there is no network security group rule to allow outside traffic on the SQL Server port (default 1433).
I have found a similar post, please refer to the following topic to see if it helps you.
https://community.powerbi.com/t5/Report-Server/Can-not-connect-to-SQL-from-VM/m-p/1453886
- You need to allow remote connections for your SQL in VM. follow steps from the article to solve the problem.
https://medium.com/@nishancw/how-to-enable-remote-connections-to-sql-server-dc5b6c812b5
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- metecakmak4 years agoNew Member
Hello,
Thank you for the detailed answer but still I'm not able to connect sql server to power bi. I just keep getting the server name was not found even though I tried every steps in the article.