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

Source: Internet
Author: User
Tags sql server management

"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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.