VS2008 (2010) Connecting to database sql2005 Unable to add data connection problems (reported missing dependencies, 89845dcd8080cc91)

"Go: http://blog.sina.com.cn/s/blog_4b5e83b40101a0w1.html"

When you create a data connection in vs2008, the following occurs:

"The data connection could not be added.

Failed to load file or assembly "Microsoft SQLSERVER.MANAGEMENT.SDK.SFC, version=10.0.0.0,culture=nutral,publickey=89845dcd8080cc91" Or one of its dependencies. The system cannot find the file specified. ”

How to deal with this?

1. Open Microsoft Corporation's Http://download.microsoft.com/download/b/b/2/bb22098a-c071-415f-9269-2eb26cefb562/instructions _chs.htm page.

2. Download the following two items here:

(1)Microsoft SQL Server 2008 Management Objects

The SQL Server Management Object (SMO) is a. NET Framework object model that software developers use to create client applications that manage SQL Server objects and services. This object model works in conjunction with SQL Server 2000, SQL Server 2005, and SQL Server 2008. Note:Microsoft SQL Server 2008 Management Objects collection needs to be installed Microsoft Core XML Services (MSXML) 6.0and Microsoft SQL Server Native Client, both programs are also available on this page.

Users: customers, partners, developers

X86 Bag(sharedmanagementobjects.msi)-3225 KB (click this link directly)
X64 Bag(sharedmanagementobjects.msi)-3895 KB
IA64 Bag(sharedmanagementobjects.msi)-5640 KB

(2)Microsoft SQL Server system CLR type

The SQL Server system CLR type package contains components for implementing the new geometry, geography, and HierarchyID types in Server 2008. This component can be installed separately from the server to allow client applications to use these types outside the server.

• X86 Bag (Sqlsysclrtypes.msi)-1588 KB (click this link directly)
  X64 Bag (Sqlsysclrtypes.msi)-1981 KB
  IA64 Bag (sqlsysclrtypes.msi)-3289 KB

• Note: This component also requires Windows Installer4.5.

  Users: customers, partners, developers

3. First install the (2) component in step 2, and then install the (1) component of Step 2.

OK, now enter vs2008, add a new data connection, everything ok!!!

(Above is the contents of the download)

I encountered this problem is to download the "X64 package (sharedmanagementobjects.msi)-3895 KB", this package is properly installed.

Hope to help the park friends

VS2008 (2010) Connecting to database sql2005 Unable to add data connection problems (reported missing dependencies, 89845dcd8080cc91)