Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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:
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?
I did not I installed it on the machine that I have powerBI on.
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:
SQL Server on Azure VM
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.