Forum Discussion

Roline's avatar
Roline
New Member
9 years ago
Solved

Unnable to connect to SQL Server 2012

Hello Community,

 

we would like to use power bi and I get no connection to our SQL Server 2012.

I have read the most posts to this topic but i don´t get it to work.

 

I want to establish a connection to my SQL Server mith "DirectQuery" and i get

only a failure Message:

 

No connection could be established...

(in german:

Details: "Fehler beim Lesen von Daten aus dem Anbieter: "Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Entweder wurde eine geforderte Identitätswechselebene nicht geliefert, oder die gelieferte Identitätswechselebene ist unzulässig. (Exception from HRESULT: 0x80070542)""

 

I have tried different logins and the SQL Login doesn´t work too.

 

Couldt please anybody help. I haven´t a clue what to do ;-)

 

Thx

  • Roline

     

    As mentioned in error message: "Could not load file or assembly 'System.EnterpriseServices". Please reinstall your .NET Framework (3.5 or above), restart your computer and try again.

     

    Regards, 

  • Hello,

     

    it installed the framework 4.5 and boot the system and now it works.

     

    Thx

     

    Problem ist solved.

     

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    Roline

     

    As mentioned in error message: "Could not load file or assembly 'System.EnterpriseServices". Please reinstall your .NET Framework (3.5 or above), restart your computer and try again.

     

    Regards, 

  • Hello,

     

    it installed the framework 4.5 and boot the system and now it works.

     

    Thx

     

    Problem ist solved.