Forum Discussion

dutchlimits's avatar
dutchlimits
Icon for Helper I rankHelper I
7 years ago

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 t...
Need Help
dutchlimits's avatar
dutchlimits
Icon for Helper I rankHelper I
7 years ago

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

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

 

 

  • dutchlimits's avatar
    dutchlimits
    Icon for Helper I rankHelper I
    7 years ago
    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. 

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      7 years ago

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

      • dutchlimits's avatar
        dutchlimits
        Icon for Helper I rankHelper I
        7 years ago

        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