Forum Discussion
Unable to Connect to SQL Server
Hello,
I just wanted to add my experience to this. As the Network Manager, I was not comfortable allowing a user to run with admin credentials, so I wanted to find a way around this issue.
I also did have to use Run As Admin to get the connection to work. I discovered that I only needed to do that to establish the connection, though. Once I did, the program could then be run without the Run As Admin option and it would work.
Hope that helps someone.
I had the same problem.
The "Run as admin" solution or .NET framework repair/new install did not work!
I resolved the issue from inside the pbix file and it was due to the automatic chnages applied in the report data source settings.
Cleared all the permissions for the data sources that had this problem (some of them were with "Windows" credentials and "Organizational" privacy level). Then, set the Credentials to Windows again with the current user authentication and privacy level to "None", all the Credentials encrypted. It worked, finally!
Hope this helps 🙂
I tried all the other solutions mentioned, this is the only one that worked for me.