cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tammylevasseur New Member
New Member

Unable to Connect to SQL Server

I have discussed this connection with our IT department and they have provided me with the correct server.  Two days ago I was able to connect and look at the tables but then the next time i tried I got the following error.

 

Unable to Connect

 

We encountered an error while trying to connect.

Detail:"An errror happened while reading data from the provider: 'Could no tloadk file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral,

PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.  Either a required impersonation level was not provided or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'"

 

Has anyone encountered this error before and what was the solution?

1 REPLY 1
Community Support Team
Community Support Team

Re: Unable to Connect to SQL Server

Hi @tammylevasseur ,

This is a problem related to SQL Server driver, I would suggest you installing the SQL Server Management Studio (SSMS) on the same machine and try again.

Besides, please try to repair the .net framework installed on your machine. You can download it from https://www.microsoft.com/en-us/download/details.aspx?id=30135

Best Regards,

Teige

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 138 members 1,654 guests
Please welcome our newest community members: