0

I must have uninstalled something recently because the Data Connections no longer work. When I try to expand the Tables node, I get this:

Microsoft Visual Studio

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

OK

What do I need to install to make it work?

Using Windows XP, VS2008 SP1

AngryHacker
  • 59,598
  • 102
  • 325
  • 594

2 Answers2

1

I believe that is a file that gets installed with SQL Server/Express 2008. It's part of SQL Management Objects (SMO).

C-Pound Guru
  • 15,967
  • 6
  • 46
  • 67
  • This is an odd error - I was connecting to my SQL Server 2005 just fine until today when a co-worker who uses 2008 touched a database file I was using. now VS2008 can't connect anymore. Grrr. – Ben Collins Nov 16 '09 at 21:56
1

I would backup any local Databases you want to keep and then uninstall and reinstall SQL Server (and reapply the latest service pack).

Mitch Wheat
  • 295,962
  • 43
  • 465
  • 541