Forum Discussion
SQL Server - we couldn't authenticate with the credentials provided
Hello,
I have been trying to connect to SQL Server all day today. The error that shows is the following:
If I press "OK" I cannot access the Data, the database comes empty. If I press cancel, sometimes it appears "we couldn't authenticate with the credentials provided". It is my first time trying to connect to SQL Server, but I did some research on this before posting.
I changed the "Named Pipes" and "Shared Memory" to Enabled,
Changed Server Authentication mode to "SQL Server and Windows Authentication mode",
Checked Maximum concurrent connections and remote connections
and connected to the server in SSMS with Server Authentication instead of Windows Authentication.
Still nothing changed. The connection I'm trying to make is local, it's not even remote. These are all changes that I made after looking for clues on why I can't connect. If someone could help me I would be really glad.
Even with Windows Authentication on Power BI I get the same error.
These are the screens of connection (just to be sure I am doing everything right)
...
Note: when I press "OK" on the error (image 1) I can see the databases in the server and the columns of each, but nothing appears in them.
Thank you,
Diego
8 Replies
Clear permissions of the credentials given and try .
Open new Power BI Window and follow the below steps
Files->Options and Settings->Data Source Settings->Clear Permissions (Clear for the required credentails given or clear all of them )
Regards,
Manikumar
Sorry I forgot to mention. I tried that a lot of times, mostly after I tried something new, also cleared the cache a few times. All that did was asking for credentials once I clicked "OK" on the error at image 1.
Did you try deleting on a empty report and tried to loggin with credentials?
Once cleared it will ask to provide credentials again.
Revently I had the same issue, I did the same thing and it worked for me. It happened multiple times this week, even today.
Regards,
Manikumar
Regards,
Manikumar
In SSMS under MSSQLSERVER01 look under Security - Logins.
Right click on Diego and choose properties.
In the "User Mapping" page select the database Pedidos and check to make sure a suitable Database role membership is selected at the bottom. It sounds like you just have public selected, when in actual fact you would want db_datareader at minimum.
This is what I currently have
That looks fine, dbo_owner is good.
In SSMS what happens if you run the following query?
SELECT * FROM PedidosCan you see results? Do you get different results when logged into SSMS using Windows Authentication or SQL authentication?
