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.
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 )
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.
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.
That looks fine, dbo_owner is good.
In SSMS what happens if you run the following query?
SELECT * FROM Pedidos
Can you see results? Do you get different results when logged into SSMS using Windows Authentication or SQL authentication?
Can you go ahead to the next step and load the data even though it is empty?
Then go to advanced editor and copy and paste the contents here?
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.