Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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