missing microsoft.sqlserver.management.sdk.sfc

sql could not load file or assembly while connecting database in Microsoft Visual Studio

To solve this problem 


Search for Feature Pack for Microsoft SQL Server 2005 - December 2008

or

Download from Microsoft web site

http://www.microsoft.com/en-us/download/details.aspx?id=11988

or click here to download the bundled pack 

You need to install following package to solve the problem

Microsoft SQL Server 2005 Management Objects Collection
The Management Objects Collection package includes several key elements of the SQL Server 2005 management API, including Analysis Management Objects (AMO), Replication Management Objects (RMO), and SQL Server Management Objects (SMO). Developers and DBAs can use these components to programmatically manage SQL Server 2005.

Note: Microsoft SQL Server 2005 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client, also available on this page.

The December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005. Install above mentioned package and register the .dll files by process below.f

After downloading the file install the file, you may view the installed file in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies

Then you must register the downloaded file using command prompt

step 1- C:\Users\ASUS>cd c:\windows\System32

step 2- C:\windows\system32>regsvr32 shell32

Then problem with missing microsoft.sqlserver.management.sdk.sfc is solved.

The .zip file contains following packages

msxml6-KB954459-enu-x86 is  Microsoft Core XML Services (MSXML) 6.0,
msxml6-KB954459 Sqlncli is  Microsoft SQL Server Native Client,

msxml6-KB954459 SQLServer2005_XMO is  Microsoft SQL Server 2005 Management Objects Collection.