Data Connection Suddently Fails Between VS 2005 and SQL Server 2000

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?
cnxmaxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepu AbrahamR & D Engineering ManagerCommented:
This errors is caused by the only partial signed XXXX.dll assembly (see AssemblyInfo.cs). As a developer, you must register this assembly for verification skipping. Open the "Visual Studio .NET Command Prompt" and cd to the installation directory. Now enter e.g.:

    sn -Vr XXXX\bin\debug\XXXX.dll
    sn -Vl

Read this:-http://p2p.wrox.com/topic.asp?TOPIC_ID=9137
0
cnxmaxAuthor Commented:
I tried this solution with the following DLL:

Microsoft.visualstudio.vspsqlenum.dll

It didn't solve the problem, but maybe are other dlls that I have to register. Any ideas about how to figure out what dependencies this dll has?
0
Deepu AbrahamR & D Engineering ManagerCommented:
Try putting AssemblyInfo.cs:
Just see this link http://www.codeproject.com/dotnet/AssemblyTest.asp 
Best Regards,
DeepuAbrahamK
0
Deepu AbrahamR & D Engineering ManagerCommented:
Use Dependency walker to find the dependend dlls.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.