Forum Discussion
Solved
We couldn't authenticate with the credentials provided - SQL Server where access is just fine
I have a SSMS connection to a SQL server that's working fine with SQL Server Authentication but I'm getting the 'We couldn't authenticate with the credentials provided' exception when trying to conne...
Found the solution, the connection from Power BI is working when entering the IP Address instead of the SQL Server Name
Inn Power BI, go to SQL connection → Advanced options → tick Trust Server Certificate, or clear cached credentials from Data Source Settings and reconnect using SQL Server Authentication. Also make sure the login has access to the selected database, not just master.
Hello Bhavin,
Thanks for looking into the question. Can you specify where you to get to these SQL Connection → Advanced Options?
I can't find them via Source or Data Source Settings