Linking to Data hosted in a SQL Server Database on Azure VM

[Anonymous]

From my understanding, the way we have our database hosted is on an Azure VM with SSMS stored locally there. I've seen a few ways of connecting using the BLOB storage, but in this case I'm not sure that is how we have it set up. Is there a way to connect to this VMs locally stored SQL Server Database?

Update: I was able to pull the server name from the system along with the authentication method, but when trying to use the credentials to log for the authentication, it is not accepting it as valid credentials.

[Anonymous]

Update: So I tried using a gateway to establish a trusted relationship between the SQL server and powerBI, but it is not allowing me to establish a connection because it is hosted in the azure classic VM. From my understanding Azure classic does not allow for gateway connections. Is the next best option here to set up PowerBI on the azure classic VM?

[GilbertQ]

Hi there

Did you install the Power BI On-Premise data gateway in the VM?

[Anonymous]

I did not I installed it on the machine that I have powerBI on.

[v-diye-msft · Accepted solution]

Hi  @Anonymous 

Are you able to connect to SQL Server using Windows login via SQL Server Management Studio in the gateway machine? If you still get same error, I am afraid that you should establish a trusted relatsionship between the two domains, which is necessary for Windows login.

You might also refer to this similar thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Credentials-are-missing-or-not-valid-inner-exception-credentials/td-p/54700 

[GilbertQ]

Hi there

Are you trying to connect to a SQL Database on an Azure VM or Blob storage?

[Anonymous]

SQL Server on Azure VM

[GilbertQ]

Hi there

Then you could connect when you have the Gateway installed either on the same VM or in a VM on the same Subnet?