We help IT Professionals succeed at work.
Get Started

Data Connection Suddently Fails Between VS 2005 and SQL Server 2000

340 Views
Last Modified: 2013-11-27
Visual Studio 2005
(Also tried Visual Studio Express 2005)
Data Connections
Connecting to Windows 2000 Server Running SQL Server 2000

For the past few weeks I've been able to add database connections to my Visual Studio Data Connections and manage databases without any issues. Suddenly when I try to connect from VS 2005 or VS Express 2005 I get the following error:

Unable to Add Data Connection.
Failed to retrieve data for this request.
Could not load file or assembly 'Microsoft.VisualStudio.vspSQLEnum, Version 9.0.242.0, Culture=neutral, PublicKeyToken=8945dc8080cc91' or one of it's dependencies. Strong name validation failed.
(Exception from HRESULT: 0x8013141A)
Strong name validation failed. (Exception from HRESULT: 0x8013141A)

As far as I can remember I haven't installed anything new or changed any configurations. As I said, this problem affects both my installed instance of VS and VS Express, so I'm thinking the problem may be on the server or having something to do with network security.

Anyone know about this one?
Comment
Watch Question
R & D Engineering Manager
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE