Forum Discussion

Lanzette's avatar
Lanzette
Regular Visitor
10 years ago

Connecting to SQL Server not possible

Hi Power BI Experts,   I created a SQL Server 2014 EE as a VM in Azure. I installed the AdventureWorks2014 sample data base and tried to connect to it with Power BI desktop. Unfortunately, it doesn...
Need Help
Lanzette's avatar
Lanzette
Regular Visitor
10 years ago

Hi ashishrj, thanks for your kind reply and your suggestion to install Power BI desktop directly on the VM in Azure.


The good news: I can connect to my database with SQL Server Management Studio like this:


I can also connect to the database with Power BI Desktop (on the VM) by simply using the server name “sql2014ee”:

 

But I don’t know how to access to the db from other computers. What is the “server” in this case?

  • Is it the website url? http://sql2014ee-87e84885.cloudapp.net/
  • Is it the IP-Address? 40.76.221.210
  • Is it the IP-Address with Endpoint (I created a new endpoint like you suggested)? 40.76.221.210:1433

I tried all of those and nothing worked.

ashishrj's avatar
ashishrj
Power Participant
10 years ago

Lanzette Try using servername.cloudapp.net

In your case it will be sql2014ee.cloudapp.net and this should work !