Connecting to SQL - Missing assembly

Question

User-434021410 posted

Hey all, 

I'm having an issue with running Visual Studio 2017 and SSMS - everytime I try and connect to a database i'm getting the following: 

TITLE: Connect to Server
------------------------------

Cannot connect to localhost\sqlexpress.

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The specified module could not be found. (System.Transactions)

------------------------------

Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The specified module could not be found.

------------------------------

Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The specified module could not be found.

------------------------------
BUTTONS:

OK
------------------------------

I've tried re-installing 3.5 (this didn't appear to install), .4.5 and 4.7.2 multiple times. The SQL server works on other machines. 

Anyone have any suggestions? Let me know if you need more information. 

Thanks 

Answer 1

User283571144 posted

Hi OwenManx,

Could you please tell me when you face the "Cannot connect to localhost\sqlexpress." error, by using SSMS or running your application?

Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The specified module could not be found. (System.Transactions)

According to this error message, your project contains a broken reference to the file 'System.EnterpriseServices.Wrapper.dll'.

I suggest you could try to uninstall and reinstall the newest Microsoft .NET. and run the configuration wizard.

Then I suggest you could try to update your windows version to newest one.

Best Regards,

Brando