- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-27-2017 08:31 AM
I keep getting the following error message when trying to connect to the companies SQL Server, does anyone have any idea of how to solve this?
"An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"
I have tried to install a newer version of .net framework but I have one that is 4.5 or newer.
"An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"
Thanks.
RDB Pro Net
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-28-2017 01:25 AM
I am having issues connecting to our SQL server, our CRM is RDB Pro Net, does anyone use the same CRM and had issues connecting to the database?
Thanks.
Re: Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-28-2017 07:28 PM
As the error message mentioned, it seems a permission issue when loading the assembly, please try to run Power BI Desktop as administrator. If it still doesn't work, please repair your .NET Framework, restart your server and try again to see if it works.
Regards,
Re: Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-16-2017 05:24 AM
Dear @v-sihou-msft ,
It worked for me running as administrator. But is there a way to make it work with a regular user?
I´m using the admin credentials for SQL connection, but wanted to run PowerBI Desktop with regular user.
Thank you,
Eduardo
Re: Unable to Connect to SQL Server
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-28-2018 08:56 AM - edited 03-28-2018 09:11 AM
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.
Re: Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-06-2018 04:42 AM
Helped me, thank you
Re: Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-19-2018 01:05 PM
Thank you. Run as admin worked for me.
Re: Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-01-2018 02:17 AM
Not sure if this helps.
I made some changes - not sure which worked!
domain admin: worked
Added domain user as local admin: didn't work (or was there some delay?)
Real SQL server name was vanguard2, so I used that at first for this SCCM power bi dashboard. Then, as we retained the original server name alias for older applications when we upgraded the server a couple of years ago, I decided to use that name 'VANGUARD' for the data connection. deleted the credentials, then it worked too.
could it be related to SPN's?
actually, when i say it worked, it stalled at a new error - my data coming from SCCM for malware has multiple records with the same data (appears to be a malware ID to name list)
Re: Unable to Connect to SQL Server
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-24-2018 02:49 PM
Run as Admin worked for me.
Vladimir
Re: Unable to Connect to SQL Server
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-05-2018 04:18 AM - edited 10-05-2018 04:25 AM
I had the same problem on my installation but only after I had installed the Microsoft Store version of Power BI Desktop. The only way I could get an SQL Database to connect as a data source was to run Power BI as administrator as mentioned by others on this thread. I uninstalled the Microsoft Store version of Power BI and pulled a manual download from the Microsoft Power BI page here :
https://powerbi.microsoft.com/en-us/downloads/ (*Make sure to select the Advanced Download Option to manually pull an installable file)
I've had no issues connecting to my databases since and I do not run Power BI Desktop as administrator. Hope this helps.