Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dutchlimits
Helper I
Helper I

MySQL connection not working anymore: access denied

Hi all

 

We're using powerbi and report server at our organisation. We've got PowerBI October 2017 installed, but it happens on the most normal recent version as well. 

 

When trying to connect to a MySQL database this error appears:

Details: "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. Access is denied.'"

 

The enviroment is installed on Server 2016, it did work flawlessly in the beginning. No clue what happened in the meantime. Havent changed anything on the server, might be an update of windows? 

 

I've tried the following but all attempts failed;

  1. Reinstall powerbi
  2. Reinstall MySQL Connector 6.6.5
  3. Install .NET Framework 4.7
  4. NetFXrepairtool
  5. Reboot server multiple times
  6. It works on other machines so its not caused by the databases itself

Nothing helps. It happens on all MySQL Server connections. 

 

Please help, 

14 REPLIES 14
dutchlimits
Helper I
Helper I
Greg_Deckler
Super User
Super User

Have you tried something like:

 

"C:\Program\Microsoft SDKs\Windows\v6.0A\bin\gacutil.exe" /i Microsoft.NET/Framework/v2.0.50727/System.EnterpriseServices.dll"

 

?

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler Our server does not contain these directory's, what are you exactly trying to do with this? 

 

By the way i forgot to say that the connection does work on other machines. But this is our PowerBI development enviroment so it must work on this server. 

https://docs.microsoft.com/en-us/dotnet/framework/tools/gacutil-exe-gac-tool


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler, unfortunately it seems that my server does not contain the folder Microsoft SDKs

I think that the intent here is to the find the path to the DLL that you want and enter that path and DLL into the gacutil as a parameter. 

 

Open a command prompt and then type:

  • cd \
  • dir System.EnterpriseServices.dll /s

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

C:\WINDOWS\system32>cd \

C:\>dir System.EnterpriseServices.dll /s
 Volume in drive C is Windows
 Volume Serial Number is B875-7992

 Directory of C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a

13-07-2016  14:33           258.048 System.EnterpriseServices.dll
               1 File(s)        258.048 bytes

 Directory of C:\Windows\assembly\GAC_64\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a

14-07-2016  14:18           245.760 System.EnterpriseServices.dll
               1 File(s)        245.760 bytes

 Directory of C:\Windows\Microsoft.NET\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a

25-09-2018  20:50           241.896 System.EnterpriseServices.dll
               1 File(s)        241.896 bytes

 Directory of C:\Windows\Microsoft.NET\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a

25-09-2018  20:50           241.376 System.EnterpriseServices.dll
               1 File(s)        241.376 bytes

 Directory of C:\Windows\Microsoft.NET\Framework\v2.0.50727

13-07-2016  14:33           258.048 System.EnterpriseServices.dll
               1 File(s)        258.048 bytes

 Directory of C:\Windows\Microsoft.NET\Framework\v4.0.30319

25-09-2018  20:50           241.896 System.EnterpriseServices.dll
               1 File(s)        241.896 bytes

 Directory of C:\Windows\Microsoft.NET\Framework64\v2.0.50727

14-07-2016  14:18           245.760 System.EnterpriseServices.dll
               1 File(s)        245.760 bytes

 Directory of C:\Windows\Microsoft.NET\Framework64\v4.0.30319

25-09-2018  20:50           241.376 System.EnterpriseServices.dll
               1 File(s)        241.376 bytes

 Directory of C:\Windows\WinSxS\amd64_system.enterpriseservices_b03f5f7f11d50a3a_10.0.14393.0_none_44fa693639cad351

14-07-2016  14:18           245.760 System.EnterpriseServices.dll
               1 File(s)        245.760 bytes

 Directory of C:\Windows\WinSxS\amd64_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14305.0_none_3df951ed8dd9fc53

16-07-2016  15:19           241.384 System.EnterpriseServices.dll
               1 File(s)        241.384 bytes

 Directory of C:\Windows\WinSxS\amd64_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14320.17035_none_f5ce3dd8bdd91d80

25-09-2018  20:50           241.376 System.EnterpriseServices.dll
               1 File(s)        241.376 bytes

 Directory of C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_10.0.14393.0_none_8ca7a00d4e46fc57

13-07-2016  14:33           258.048 System.EnterpriseServices.dll
               1 File(s)        258.048 bytes

 Directory of C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14305.0_none_85a688c4a2562559

16-07-2016  15:20           241.896 System.EnterpriseServices.dll
               1 File(s)        241.896 bytes

 Directory of C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14320.17035_none_3d7b74afd2554686

25-09-2018  20:50           241.896 System.EnterpriseServices.dll
               1 File(s)        241.896 bytes

     Total Files Listed:
              14 File(s)      3.444.520 bytes
               0 Dir(s)  88.227.123.200 bytes free

This is the output

 

Tried finding gacutil.exe no success. Might need to install it. 

Hmm, the following lines show that it is in the GAC

 

Directory of C:\Windows\Microsoft.NET\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a 25-09-2018 20:50 241.896 System.EnterpriseServices.dll 1 File(s) 241.896 bytes

 

Directory of C:\Windows\Microsoft.NET\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a 25-09-2018 20:50 241.376 System.EnterpriseServices.dll 1 File(s) 241.376 bytes

 

So, the interesting part to me is the "Access is denied". That seems very odd. 

 

If you have a Pro account, I would report this as an issue.

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I don't have a pro account at this moment. Might look into this later on. 

 

Is there a way to fix this easily?  We really need this to be working again. I find it odd that it still doens't work after reinstalling powerbi, the mysql connector, and upgrading .net 

I probaly found the cause. A windows update:  

https://support.microsoft.com/en-us/help/4345418/windows-10-update-kb4345418

 

The following update should fix it: 

http://www.catalog.update.microsoft.com/Search.aspx?q=KB4346877

 

Im trying it out right now 

Any update on this? We need this data for board reports and with the connection no longer working we will have to very quickly build it manually.

I'd wish to have the answer. We still have the same issue. 

Please let us know if that works!

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I had high hopes, but NOPE! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.