Forum Discussion
Connecting to a remote SQL Server using the DirectQuery method
Your original post indicated that when designing a Power BI model that was to connect to SQL Server, you got an error stating that it could not find that SQL server on the network. You are desiggning from you LOCAL MACHINE correct? Does that LOCAL MACHINE have the ability to connect to the SQL Server?
Super UserHave you tried with supplying a Database Name?
Thanks for your reply. I have tried providing the database name, still no connection was made.
The database is secured with a username and password and it seems impossible to connect to it without providing any credentials.
- ToddChitt
>>The database is secured with a username and password and it seems impossible to connect to it without providing any credentials.<<
Is this a surprise to you? What happens when you supply theese? Do you even have them? If not, that's not Power BI's fault.
Me to my mechanic: My car won't start!
My Mechanic: OK, let me have the keys and I will try it.
Me: I don't have the keys.
🙂
Obviously I do have the credentials (I did manage to set up the gateway which requires db authentication). As I mentioned before: There is no appropriate place to provide the db credentials as well as choosing to connect to the gateway. What I'm asking is if there is a way to connect to a SQL Server which is NOT on my local machine?
- ToddChitt
The error in the orgininal post indicated that Power BI could not find the SQL Server. Let's start there. Can you connect to that SQL instance via SSMS or some other SQL client FROM YOUR LOCAL MACHINE?