cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dutchlimits Regular Visitor
Regular Visitor

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 Regular Visitor
Regular Visitor

Issues with PowerBI on a Server 2016 machine

Super User
Super User

Re: MySQL connection not working anymore: access denied

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"

 

?

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


dutchlimits Regular Visitor
Regular Visitor

Re: MySQL connection not working anymore: access denied

@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. 

Super User
Super User

Re: MySQL connection not working anymore: access denied

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


dutchlimits Regular Visitor
Regular Visitor

Re: MySQL connection not working anymore: access denied

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

Super User
Super User

Re: MySQL connection not working anymore: access denied

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


dutchlimits Regular Visitor
Regular Visitor

Re: MySQL connection not working anymore: access denied

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. 

Super User
Super User

Re: MySQL connection not working anymore: access denied

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".


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


dutchlimits Regular Visitor
Regular Visitor

Re: MySQL connection not working anymore: access denied

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