Forum Discussion
Unable to connect to SQL Server - Logon failed for login
Hi Ross,
The issue has been resolved. It turns out I needed to be 'whitelisted' to be able to access it, which I now am and it is working fine.
Thanks for your assistance.
Regards,
Thanks for your response Ross.
I had found that article earlier but unfortunatly it doesn't help me. It sounds like the same issue but I have no backround in sql and have just been provided with the server details, so what the article is suggesting is outside my realm of knowledge.
I will forward it to the third party who supplied the access to the server and see if they can utilise it.
In my searching I haven't been able to find any other instences where this has occured through Power BI.
Were you provided SQL statements (or stored procedure) along with your access, or were you simply attempting to connect so you could go directly to a Table?
Based on the article, i was wondering if the issue might stem from the code being run and perhaps the solution may lie with those that wrote the code for you.
If you were going directly to a table and letting Power BI write the SQL code, that would tell a different story. In that case, it would certainly be a strange error, but hopefully your database administrators might have some insight for you.
Hi Ross,
The issue has been resolved. It turns out I needed to be 'whitelisted' to be able to access it, which I now am and it is working fine.
Thanks for your assistance.
Regards,