Unnable to connect to SQL Server 2012

[Roline]

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

[v-sihou-msft · Accepted solution]

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

[Roline · Accepted solution]

Hello,

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

Thx

Problem ist solved.

[v-sihou-msft · Accepted solution]

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