Accessing SQL 2005 from Visual Studio 2008

Posted: 07-05-2009 | Author: flexicoder | Category: SQL Server

If you are attempting to add a data connection to a SQL 2005 database within visual studio 2008 you might encounter the following error…

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.

You need to install the following…

Microsoft SQL Server System CLR Types
Microsoft SQL Server 2008 Management Objects

They can be found here as part of the SQL Server 2008 Feature Pack.


Category: SQL Server by flexicoder

One Response to “Accessing SQL 2005 from Visual Studio 2008”

  1. Babu, on May 29th, 2009 at 6:21 am Said:

    Thanks for sharing this Paul. I had this same issue today after I re-installed SQL server 2005 post removal SQL server 2008.

    Cheers
    Babu

Leave a Reply