Forum Discussion

caracarn's avatar
caracarn
New Member
9 years ago

Unable to Connect to SQL Server

I am trying to connect to an internal SQL Server.  As suggested on other threads I found here, I have loaded SSMS on my machine and can successfully connect to the DB that way.  I have cleared out th...
Need Help
JamesHinton's avatar
JamesHinton
Frequent Visitor
9 years ago

It seems that your data source settings may have changed.  Go to File, Options and Settings, Data Source Settings, and check/confirm Credentials, Encryption (set it to Off) and Privacy Level (try None).

 

 

 

Sébastien-JLD's avatar
Sébastien-JLD
New Member
9 years ago

Good afternoon,

 

I am a new Power BI user and cannot connect as well to a database on the SQL Server. I have the following error and I don't know where to find the solution. Thanks a lot for your help :

 

« Une erreur s'est produite pendant la lecture des données du fournisseur : 'Impossible de charger le fichier ou l'assembly 'System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' ou une de ses dépendances. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception de HRESULT : 0x80070542)' »

  • JamesHinton's avatar
    JamesHinton
    Frequent Visitor
    9 years ago

    Hi Sebastien,

     

    Unfortunately I am not a SQL expert.  However,

    have you confirmed that the credentials you are employing do in fact allow a remote connection to the SQL Server?

     

    Regards,

     

    James

    • Sébastien-JLD's avatar
      Sébastien-JLD
      New Member
      9 years ago

      Hi James,

       

      Thanks for your post. Yes, the credentials used is able to make a remote connection and it is the administrator of the SQL Server.